If the source file is closed and the table array is more than 16735 rows
Excel complains by returning #N/A.

--
Biff
Microsoft Excel MVP


"baxtermcc" wrote in message
...
I have no trouble getting the VLOOKUP function to return an #N/A when the
Table_array is on the same workbook. However, when I build a VLOOKUP
entry
with the Table_array located in a linked workbook I get only the #VALUE
response. In both cases the Range_lookup = FALSE.

Anyone with experience with this problem willing to lend assistance would
be
appreciated.

Thanks,
Bob