View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 57
Default 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