Forum Discussion
Getting a value in one cell, if a cell matches a another cell.
I'm looking for help coming up with a formula to solve the problem below... In column A I have a list of names in a random order. In column B I have a unique numerical ID number associated with ...
Hi Matt,
Assuming that the 1st name starts at the cell A1, Enter this formula in D1 "=VLOOKUP(C1,A:B,2,FALSE)" and drag it down.. You will get what you are looking for. hope this helps.
Hello Rajashekhar Sheelvant
How would I get vlookup to ignore the first 1-6 matches and choose the next match if it already found a match and populated in C24-C30. The issue I am running into is I have 3 teams with three emp's each. If vlookup "C24-C30" already matched 3 to Abel, the first match, I can't get it to ignore and go to the next match??
Thanks in advance for any advice you have!