Lookup Function

%3CLINGO-SUB%20id%3D%22lingo-sub-3435350%22%20slang%3D%22en-US%22%3ELookup%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3435350%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20update%20a%20spreadsheet.%20I%20need%20it%20to%20look%20up%20and%20pull%20a%20description%20from%20Sheet%201%2C%20that%20corresponds%20with%20a%20number%20that%20is%20entered%20into%20the%20sheet%20titled%20%22Form%22.%20Basically%2C%20I%20need%20to%20be%20able%20to%20enter%20in%20a%20material%20number%20and%20then%20have%20the%20cell%20underneath%20it%20generate%20the%20material%20description%20based%20on%20the%20number%20that%20was%20entered.%20I%20have%20tried%20several%20functions%20including%2C%20%22Lookup%22%2C%20%22Vlookup%22%2C%20%22Index%22%2C%20and%20%22Match%22%20and%20I%20am%20not%20having%20any%20luck.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20number%20is%20being%20entered%20into%20%22R6C4%22%20and%20the%20description%20needs%20to%20go%20into%20%22R8C4%22.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3435350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3435442%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3435442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1403605%22%20target%3D%22_blank%22%3E%40k8lynglss%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DINDEX(Sheet1!B%3AB%2C%20MATCH(%20D6%2CSheet1!A%3AA%2C%200)%20)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eif%20in%20Sheet1%20column%20A%20are%20numbers%20and%20in%20column%20B%20are%20descriptions%20for%20these%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3435498%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3435498%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1403605%22%20target%3D%22_blank%22%3E%40k8lynglss%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DVLOOKUP(D6%2CSheet1!%24A%242%3A%24B%2419%2C2%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EAn%20alternative%20could%20be%20VLOOKUP.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to update a spreadsheet. I need it to look up and pull a description from Sheet 1, that corresponds with a number that is entered into the sheet titled "Form". Basically, I need to be able to enter in a material number and then have the cell underneath it generate the material description based on the number that was entered. I have tried several functions including, "Lookup", "Vlookup", "Index", and "Match" and I am not having any luck. 

The number is being entered into "R6C4" and the description needs to go into "R8C4". 

2 Replies

@k8lynglss 

That could be like

=INDEX(Sheet1!B:B, MATCH( D6,Sheet1!A:A, 0) )

if in Sheet1 column A are numbers and in column B are descriptions for these numbers.

@k8lynglss 

=VLOOKUP(D6,Sheet1!$A$2:$B$19,2,FALSE)

An alternative could be VLOOKUP.