VLOOKUP issue with #N/A - linked workbook

[baxtermcc]

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

 

[Sheeloo]

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...

 

[T. Valko]

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

 

[baxtermcc]

If the Lookup_value exists in the Table_array the correct data is returned.

I want to make sure I know when the lookup is invalid by setting
Range_lookup to FALSE, however, when a valid Lookup_value is not found in the
Table_array the function is returning #VALUE instead of #N/A.

I can make VLOOKUP return #N/A in a small test case when the Table_array is
located in the same workbook as the VLOOKUP call, I am not having any success
when the Table_array is in a linked workbook.

Thank you,
Bob