May 26 2022 12:20 PM
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".
May 26 2022 12:39 PM
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.
May 26 2022 12:50 PM