Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP issue with #N/A - linked workbook
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP issue with #N/A - linked workbook
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP issue with #N/A - linked workbook
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP issue with #N/A - linked workbook
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 "Sheeloo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format issue to linked cells | Excel Worksheet Functions | |||
Obscure issue - recalculating linked pictures! | Excel Discussion (Misc queries) | |||
pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
VLOOKUP not calculating - workbook protection issue? | Excel Discussion (Misc queries) | |||
VLOOKUP not calculating - workbook protection issue? | Excel Discussion (Misc queries) |