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?
5 Replies
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
- Create a table in the worksheet that has the email address and link to it via the common customer number using vlookup function
thnaks for the quick response I will try that!
