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