Array formula & #N/A

[Excel 2007 - SPB]

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

 

[T. Valko]

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

 

[PSB]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!