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