#n/a Formula check.

**coolhit** · 07-13-2009, 05:43 AM

Hi,

could someone please help me. i have writen the following formula. It works fine but cel still have #n/a and want them to be blank.

IF(ISNA(VLOOKUP(C309,'Consumables Codes'!$B$1:$F$200,5,FALSE)),VLOOKUP(C309,'Consumables Codes'!$C$1:$F$200,4,FALSE),VLOOKUP(C309,'Consumables Codes'!$B$1:$F$200,5,FALSE))

i belive i have not inserted (=true, " ", ) some in this formula but not sure where it goes.

Many thanks in advance

**DonkeyOte** · 07-13-2009, 05:48 AM

One approach

Please Login or Register  to view this content.

**coolhit** · 07-13-2009, 05:54 AM

Hi

could you help me correct #n/a "consumable in AM rack sheet"

password is consumables

**JimmyA** · 07-13-2009, 06:01 AM

Hi

This formula is proabably a long winded way of doing it but it works for me.

Eg for Cell D308

Please Login or Register  to view this content.

Cheers

Jim

**DonkeyOte** · 07-13-2009, 06:01 AM

Do not post duplicate threads - this is against Rule 5 of our forum rules. I have merged your two threads.

**martindwilson** · 07-13-2009, 06:54 AM

=IF(AND(ISNA(MATCH(C5,'Consumables Codes'!B:B,0)),ISNA(MATCH(C5,'Consumables Codes'!C:C,0))),"",IF(ISNA(MATCH(C5,'Consumables Codes'!B:B,0)),VLOOKUP(C5,'Consumables Codes'!C:F,4,FALSE),VLOOKUP(C5,'Consumables Codes'!B:F,5,FALSE)))