How to find linked record ID from text field

[KK80]

Hi

I'm moving my automations from Zapier to Make and I'm struggling to get the airtable automations to work in the same way.

Previously, when pulling the automation from Teamwork, the websites field showed a record ID, which then haulted the other linked fields.  I then created the Websites copy column to turn the Record ID into text.  

Make does this differently and pulls the tag in as text, so I need to find a way to do the reverse, ie using the text in the Websites Copy column to find the matching record ID on another table, thus allowing the other lookup fields to function.

I'm not sure if any of that makes sense, but any help for this rookie is much appreciated.

TIA