Hello,
Here is what I have. There is one spreadsheet with 2 sheets. One sheet 1 I have names and email addresses from a csv output on newsletter system. On sheet 2 I have hundreds of lines from a customer search engine (name, company, email, etc).
What I am trying to do is take the email list from sheet one. Search sheet 2, if it finds the same email address, then copy over (company name, address, position, phone number, etc).
I have been searching for days and still having problems finding a formula that will work.
Any help would be greatly appreciated.
Tony