Alex W.

Sorry for the delay - can we please open this back up? I was able to lookup the records from the other table in my main table, but now I need to filter the full set of records based on a result of the investor lookup table. Essentially, I want to output a column in the main table that pulls only investors who were found to be VC partners. There is a field in each record pulled called ‘VC Partner?’ and I’d like to filter on that. Here’s a link to the table again for reference, thanks for your support! https://app.clay.com/workspaces/194445/workbooks/wb_p2gGKDgsCE4U/tables/t_evenhXCMTcSZ/views/gv_ILsmHsNiy6BB

Bo (. this is extremely helpful, thanks so much! I was able to get the lookup working in a separate ‘Investor Data’ table. Last step - how can I roll the data from this Investor Data table back up in my main client table? Here’s the link to the workbook: https://app.clay.com/workspaces/194445/workbooks/wb_BdcNurqFkNdX/tables/t_gqN2ZMxTEm5s/views/gv_xZ9WMKwiZsdD

Thanks for the reply Tanvi R.! I’ve tried this, but my issue is a little more complicated than a simple lookup. I have a column that contains a comma-separated list of all the company’s investors, and I need to check whether any part of that column’s string is contained in a row in our VC Partners table. Example: a company’s Investors column might be “Matrix Partners, Passport Capital, Bow Capital, General Catalyst” and I need the lookup to check whether ‘Matrix Partners’ OR ‘Passport Capital’ OR ‘Bow Capital’ OR ‘General Catalyst’ is listed in our VC Partners DB.