Are you able to get a positive match? I mean is your VLOOKUP returning the
correct value if what you are looking for is present in the lookup range?

There should not be any difference just because your lookup range is located
in another workbook...

"baxtermcc" wrote:

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