Hi!

The only "error proof" way to do this is to write a separate lookup formula
for each sheet of the other file.

There is a method that uses the INDIRECT function but this is not error
proof! It requires the other file be open but as soon as you close the other
file and the active file recalculates you get errors.

There is also a VBA utility out there but a lot of people who try it also
seem to have problems using it.

Biff

"JJC" wrote in message
...
I have a vlookup that goes out to another file.

Because the other file has several worksheets it is only searching on the
worksheet that was selected is there any way to get the vlookup to look at
all the worksheets within a workbook.

Here is my statement.
=VLOOKUP(A19,'[New Monthly Invoices June 05.xls]Aug 05'!$D$1:$S$2,16)

It works fine, but only for the Aug 05 Sheet within the other workbooks,
please help me to search the entire workbook for this.

Thanks,

JJC