Getting a value in one cell, if a cell matches a another cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-125248%22%20slang%3D%22en-US%22%3EGetting%20a%20value%20in%20one%20cell%2C%20if%20a%20cell%20matches%20a%20another%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125248%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20for%20help%20coming%20up%20with%20a%20formula%20to%20solve%20the%20problem%20below...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20column%20A%20I%20have%20a%20list%20of%20names%20in%20a%20random%20order.%3C%2FP%3E%3CP%3EIn%20column%20B%20I%20have%20a%20unique%20numerical%20ID%20number%20associated%20with%20each%20name%20in%20column%20A.%3C%2FP%3E%3CP%3EIn%20column%20C%20I%20have%20the%20same%20names%20as%20column%20A%20but%20in%20a%20different%20order.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20in%20column%20D%20I%20would%20like%20to%20create%20a%20formula%20that%20checks%20the%20adjacent%20name%20in%20column%20C%2C%20matches%20it%20against%20the%20same%20name%20in%20column%20A%2C%20and%20then%20takes%20the%20numerical%20ID%20in%20column%20B%20associated%20with%20that%20name%2C%20and%20puts%20that%20for%20the%20Value%20in%20the%20cell%20in%20column%20D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20way%20my%20Data%20is%20kept%20and%20arranged%20I%20am%20unable%20to%20simply%20sort%20alphabetically%20and%20then%20paste%20the%20numerical%20ID%20so%20I%20am%20looking%20for%20a%20work%20around.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20help%20with%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-125248%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-126417%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20a%20value%20in%20one%20cell%2C%20if%20a%20cell%20matches%20a%20another%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-126417%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Rajashekhar!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20worked%20perfectly!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-125358%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20a%20value%20in%20one%20cell%2C%20if%20a%20cell%20matches%20a%20another%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125358%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Matt%2C%3C%2FP%3E%3CP%3EAssuming%20that%20the%201st%20name%20starts%20at%20the%20cell%20A1%2C%20Enter%20this%20formula%20in%20D1%20%22%3CSTRONG%3E%3DVLOOKUP(C1%2CA%3AB%2C2%2CFALSE)%3C%2FSTRONG%3E%22%20and%20drag%20it%20down..%20You%20will%20get%20what%20you%20are%20looking%20for.%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

3 Replies

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!

@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?