Or Function and #NA
I am using an OR function with two different VLookup function within each of
the Or logical statements. I know that one of the two Or logical arguments will not return any data, but the other will. Because the one returns an #NA, the whole formula returns #NA. Here is the formula. =OR(VLOOKUP(B3,'C:\Documents and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE),VLOOKUP(B3,'C:\Documen ts and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$J$29:$K$38,2,FALSE)) Any help, Biff |
Or Function and #NA
I believe I'd use a nested IF statement here, although that may not give the
results you want because if the first VLOOKUP() returns anything, then the second one wouldn't be performed. In any case, to prevent the N/A error, wrap up each VLOOKUP() like this IF(ISNA(VLOOKUP(B3,'C:\Documents and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE),"",VLOOKUP(B3,'C:\Docu ments and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE)) that will cause an empty string to be returned when an #N/A would have been returned without the wrap. "Biff" wrote in message ... I am using an OR function with two different VLookup function within each of the Or logical statements. I know that one of the two Or logical arguments will not return any data, but the other will. Because the one returns an #NA, the whole formula returns #NA. Here is the formula. =OR(VLOOKUP(B3,'C:\Documents and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE),VLOOKUP(B3,'C:\Documen ts and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$J$29:$K$38,2,FALSE)) Any help, Biff |
Or Function and #NA
Now I get a #Value error message.
"JLatham" wrote: I believe I'd use a nested IF statement here, although that may not give the results you want because if the first VLOOKUP() returns anything, then the second one wouldn't be performed. In any case, to prevent the N/A error, wrap up each VLOOKUP() like this IF(ISNA(VLOOKUP(B3,'C:\Documents and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE),"",VLOOKUP(B3,'C:\Docu ments and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE)) that will cause an empty string to be returned when an #N/A would have been returned without the wrap. "Biff" wrote in message ... I am using an OR function with two different VLookup function within each of the Or logical statements. I know that one of the two Or logical arguments will not return any data, but the other will. Because the one returns an #NA, the whole formula returns #NA. Here is the formula. =OR(VLOOKUP(B3,'C:\Documents and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$A$2:$D$291,4,FALSE),VLOOKUP(B3,'C:\Documen ts and Settings\alex\Desktop\[Model Summary - Tamarac.xls]Model Level Reference Codes'!$J$29:$K$38,2,FALSE)) Any help, Biff |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com