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	684	October 28, 2021
Query a common matching field in two tables by formula (Company name)	5	570	November 29, 2019
Lookup Formula with two values	5	524	July 20, 2021
If name & date match -> change value	11	615	July 8, 2021
Return values by matching tables	4	179	April 10, 2024