I tried to use Vlookup in a spreadsheet to extract data from a different
spreadsheet in the workbook. It complained about having the spreadsheet name
in the table array.

It worked fine if I put the vlookup commands in the same spreadheet.

So the questions is can you use vlookup to lookup data in a different
spreadsheet (same workbook) and if so what is the syntax?

Don C