Looking for formula help. Table#1 (contacts) has customer contacts with name, email, etc. Table #2 (payments) has payment information from customers. The main matching field is names, though its not always 100% match. I want to search table #1 for name matches, then populate table #2 email field…

Something like this? [image] Scraping data from the another table's row Like this?

Lookup formula to populate a column based on a name search/match in another table

Nick_Milner June 4, 2019, 9:34pm 4

Something like this?

Topic		Replies	Views
Lookup Formula Using a Lookup Column	4	742	October 28, 2021
Return data from fields in same row after lookup	2	1568	March 7, 2019
Query a common matching field in two tables by formula (Company name)	5	621	November 29, 2019
Lookup Formula with two values	5	598	July 20, 2021
Issue with a lookup formula	1	346	April 13, 2022