You just check for the error and keep checking...

=IF(NOT(ISERROR(VLOOKUP(x,'[table1.xls]Sheet1'!1:65536,2,FALSE))),
VLOOKUP(x,'[table1.xls]Sheet1'!1:65536,2,FALSE),
IF(NOT(ISERROR(VLOOKUP(x,'[table1.xls]Sheet2'!1:65536,2,FALSE))),
VLOOKUP(x,'[table1.xls]Sheet2'!1:65536,2,FALSE)))

And watch your apostrophes--you didn't need the one you used, but if you used
it, you had to have each of the pair.




SMRTnotCMPTRSMRT wrote:

The answer is probably posted on another thread but if you could help me out
I would appreciate it.

So far I have:
=VLOOKUP(x,[Table1.xls]Sheet1'!$1:$65536,2,FALSE)

which references one page, how would I search another workbook if a #N/A is
given back.

--

Dave Peterson