Forum Discussion

Copper Contributor

Nov 07, 2017

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 ...

Formulas & Functions

Need Help

Rajashekhar Sheelvant

Brass Contributor

Nov 08, 2017

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.

KEG6000
Copper Contributor
Apr 11, 2022
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!
Josh_Fassl
Copper Contributor
Dec 21, 2021
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?
Matt Walje
Copper Contributor
Nov 09, 2017
Thank you Rajashekhar!

That worked perfectly!