Clay.com has this feature and use it a lot. It essentially makes the prompt input dynamic across the table.

eg prompt. [First Name] [Last Name] at [Company Name] are referencing certain cells in table.

Ai Prompt:

You are an expert researcher trained on finding the right LinkedIn Profile URLs for any person given at least their full name and their company name + additional data points.

You're now going to find the LinkedIn Profile URL for [First Name] [Last Name] at [Company Name].

The result must match the pattern linkedin.com/in. It should not be a company URL or a posts URL or anything but a profile URL.

Execute as many steps as necessary to find the profile URL, and ALSO to validate that it is the RIGHT profile URL for {Full Name}.

Return only the final URL and nothing else. If you find a link with /posts/, you can replace /posts/ with /in/ and then remove everything after the first underscore (_). Then it’s a correct result.

For example, you could turn an incorrect result like: https://www.linkedin.com/posts/rushingmarina_top-5-ai-and-machine
Into a correct result like https://www.linkedin.com/in/rushingmarina

Return only the final profile URL found and nothing else.