Vlookup

[MTVLGL]

I am trying to use VLOOKLUP to match a value to a worksheet in the same workbook. The data is contained in spreadsheet #2, with column A as the number and column B as the description, I need to match this number to the number in spreadsheet#1 (listed in column F in this spreadsheet) , then return the description that matches that number from spreadsheet #2

[Cutter]

You didn't say where you wanted the answer but I'll assume in column G so:

If you want to find the answer for a number in F2, in G2 type:
=VLOOKUP(F2,Sheet2!A$2:B$500,2,FALSE)

Change the 500 value I used to the row number of the last cell containing data in your list on Sheet 2 (or any number you want that is higher than your last row number)

[MTVLGL]

Thanks - great help.