Hi all,
Been a long time since I have been on here, really hoping someone can help me out.
See the attached.
The WWN values in Column E of sheet data1 - I need, in column F, the corresponding alias as shown in column A in sheet data2.
So, cell E2 on sheet data1 matches the alias in cell A2 in sheet data2. I need a formula that looks at all the WWNs in "data1" and then matches them to the alias in "data2", and returns the matching value into column f in data1.
Hope that makes sense
this should do it but it looks like it only returns one match.
=INDEX(data2!$A$2:$A$9,MATCH(data1!E2,data2!$B$2:$B$9,0))
And if you need it to return a message indicating the WWN isn't in data2 then this would work.
=IFERROR(INDEX(data2!$A$2:$A$9,MATCH(data1!E2,data2!$B$2:$B$9,0)),"not present in data2")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
you are my new best friend. Thank you!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks