VLookup Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1507325%22%20slang%3D%22en-US%22%3EVLookup%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507325%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20take%20look%20up%20matching%20values%20from%20multiple%20sheets%20and%20return%20a%20value%20in%20anther%20column.%26nbsp%3B%3C%2FP%3E%3CP%3EExample%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20B2%20to%20be%20looked%20up%20against%20sheet3%3A%20C2%3AC3964%20and%20if%20matched%20return%20the%20value%20in%20column%20D%20in%20sheet%203.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense.%26nbsp%3B%3C%2FP%3E%3CP%3ECG%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1507325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1507910%22%20slang%3D%22en-US%22%3ERe%3A%20VLookup%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721666%22%20target%3D%22_blank%22%3E%40Geterc%3C%2FA%3E%26nbsp%3BThe%20%3CSTRONG%3Ebasic%3C%2FSTRONG%3E%20formula%20for%20that%20would%20be%20(with%20either%20commas%20or%20semi-colons%20separating%20the%20arguments%20within%20the%20function%2C%20depending%20on%20the%20local%20settings%20in%20your%20Excel)%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DVLOOKUP(B2%2CSheet3!C2%3AD3964%2C2%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIf%20you%20are%20on%20a%20modern%20version%20of%20Excel%2C%20the%20new%20XLOOKUP%20function%20will%20probably%20be%20a%20better%20option.%3C%2FP%3E%3CP%3EMore%20about%20these%20functions%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to take look up matching values from multiple sheets and return a value in anther column. 

Example 

I want B2 to be looked up against sheet3: C2:C3964 and if matched return the value in column D in sheet 3. 

 

Hope this makes sense. 

CG

1 Reply

@Geterc The basic formula for that would be (with either commas or semi-colons separating the arguments within the function, depending on the local settings in your Excel):

=VLOOKUP(B2,Sheet3!C2:D3964,2,FALSE)

If you are on a modern version of Excel, the new XLOOKUP function will probably be a better option.

More about these functions here:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1