Forum Discussion
Lookup Function
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 abl...
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.