=IF(A1="F",IF(A2<"",LOOKUP(A2,"CAS",2440;"EMF",24 10;"ENG",2660;"INP",2450;"POL",2420;"SLS",2100}),2 280),IF(A1="T",IF(A2<"",LOOKUP(A2,{"SRP",3130;"TB B",3160}),3160),""))

Bu tht above formula is actually giving me the closest value even when the
condition is not met. Can someone help me in fixing this in such a way that
if the condition is not met it should error out. Thanks in advance