Create a link based on table date on another website : <p>I am trying to think about how I would go about creating a link to something based on a data in another table on another website.</p>

<p>I have the following table on the other website:</p>

<p><a href="https://i.imgur.com/Hlemt1y.jpg" rel="nofollow noreferrer">https://i.imgur.com/Hlemt1y.jpg</a></p>

<p>so basically columns: Order #, Status, customer P-O</p>

<p>What I am trying to do is create a url based on "customer PO" that links to the Order #. So it would find the customer PO, then check the value on the same row of Order #, and then once I have that value I can create the URL using that order #.</p>

<p>I've never done anything that takes a value from another website so I guess that is what I am after? </p>
