Nov 07 2017
- last edited on
Jul 25 2018
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 each name in column A.
In column C I have the same names as column A but in a different order.
Then in column D I would like to create a formula that checks the adjacent name in column C, matches it against the same name in column A, and then takes the numerical ID in column B associated with that name, and puts that for the Value in the cell in column D.
The way my Data is kept and arranged I am unable to simply sort alphabetically and then paste the numerical ID so I am looking for a work around.
Thanks in advance for any help with this.
Nov 07 2017 10:52 PM
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.
Dec 21 2021 07:00 AM
@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?