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.