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 with the matching customer email from tbl#1, so that I can send payment confirmation emails.
Read up, watched a bunch of videos etc but still struggling with the formula.
This is what I have…would appreciate some help!
Lookup(Contacts-tbl1,thisRow.Name-tbl2 ,[E-mail 1 - Value-tbl1])
This may be way off but was trying to follow some formulas I’d seen. I’m wondering if the Find() formula would come into play here but have struggles to structure it.