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.
Thank you Rajashekhar!
That worked perfectly!