Removing #N/A using ISNA

[Jacaspace]

Hi,

I am trying to remove #N/A in this formula, how can I insert ISNA so that #N/A is no more in place?

Basically, I am trying to look for a invoice number and its value and compare it to old invoice data to check if it was already booked. Have used concatenate to combine the invoice number and its value (so that if same invoice is booked with difference value - my formula picks up)

Data is returning with #N/A value for new invoices which were not booked. And I am unable to insert the INSA in below formula. Can someone help me with this?


=IF(C4="","",VLOOKUP(CONCATENATE('Invoice Download'!C4&'Invoice Download!J4),'Old Invoice 2011'!$H:$Q,10,0))


Thanks & Regards to all of you!

[Domski]

What do you wan't it to do if it returns #N/A?

Dom

[Jacaspace]

Hi Dom,
Thanks for the post! I want the field to be blank.

Would appreciate your help!

B.Rgds,

[Domski]

Try this:

=IF(OR(C4="",ISNA(VLOOKUP(CONCATENATE('Invoice Download'!C4&'Invoice Download!J4),'Old Invoice 2011'!$H:$Q,10,0))),"",VLOOKUP(CONCATENATE('Invoice Download'!C4&'Invoice Download!J4),'Old Invoice 2011'!$H:$Q,10,0))

Dom

[Jacaspace]

Hi Dom,

Nice one! Worked perfect.. with bit of tweak where I removed C4="" and the rest went through

Thanks a lot!