Matteo Greenberg

Need Help with Cross-Table Lookups in Clay's Formula Generator

Hi Clay Support I’m trying to match data from Find Jobs Table to my Find People table to my using Clay’s formula generator, but:

The slash-menu won’t let me insert columns from another table
My manual lookup("Find Jobs Table", "Company Domain", thisRow["Company Domain"], "Job LinkedIn URL") formulas return blank
I need to pull both the Job URL and Job Description into my people rows by matching on Company Domain respectively (theres 5 people per company)

Can you help me write the correct formula (or point out what I’m missing) so these cross‐table lookups work?

3 attachments

Would love to