I have a file with duplicate names of test id's in col a. In col b I have single test id's and col c I have test names. I need to search col a for exact match of test id in col b and if it is there then put the name of test in col c into col d.
See attached document. Basically I need to know the name associated with the ID in column B.
Thanks in advance for help. I need a formula to do this.
Tami
D2:
=IFERROR(LOOKUP(2,1/(B2=$A$2:$A$9531),$C$2:$C$9531),"No Match")
And copy down.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
shinereed, Good evening.
Take a look at this example.
19-03-2014_Compendium.xlsx
Is this what you want?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Thread posted in Commercial services hence closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks