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.
Rajashekhar Sheelvant I'm struggling with a vlook up. I would like it to look up column C, compare it to column A in another sheet, and return the value in column B from the other sheet? Can you help?