Vlookup multiple worksheets

S

SMRTnotCMPTRSMRT

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.
 
D

Dave Peterson

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.



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.
Click to expand...
 
K

Kleev

I originally mistakenly you were asking to do a lookup on a different sheet
rather than a different workbook, but luckily, when I moved my sheet to a
different workbook, Excel changed my formulas accordingly. This would appear
to be what you are asking for. Note, it will return an #n/a if it also isn't
 
Top