Lookup Function

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


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.



An alternative could be VLOOKUP.