Forum Discussion
Matching cusomer # to email
Hello, I have a 2 worksheets, both have cusomer data with unique cusomer #s, only one has the email address.....how do I match the email address from 1 worksheet to the same customer in the other...
If both have unique numbers as IDs, you may use VLOOKUP or INDEX/MATCH to add emails, like
=IFNA(INDEX( Sheet2emails, MATCH(ID, Sheet2IDs, 0)),"no such customer")
Thnak you! I tried the match and it worked great!
Nick_Pione1450 , you are welcome