Array formula & #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the array formula below which gives me a result when there is data but
when the data is missing, which is what I am checking for I get "#N/A" I
would like it to be a blank cell, ("") I have tried using "=if(isna( " and
combination, but get a too many arguments for this function error

{=index(Lpilot,match(1,(text(ldate,"ddmmyy")=text(#a136,"ddmmyy"))*(B$129=Ltype),0))}

any ideas / help

SPB
 
Try this (array entered):

=IF(ISNA(MATCH(1,(TEXT(ldate,"ddmmyy")=TEXT($A136,"ddmmyy"))*(B$129=Ltype),0)),"",INDEX(Lpilot,MATCH(1,(TEXT(ldate,"ddmmyy")=TEXT($A136,"ddmmyy"))*(B$129=Ltype),0)))

In the formula you posted you have:

#a136

I assume that's supposed to be: $A136
 
Thanks, I though I tried this but it works now! I tried to paste & copy the
repeated info, maybe it did not like my time saver...

SPB
 
Back
Top