=if(A1="A-0001",1.5,if(A1="A-0002",1.55,if(A1="B-0001",1.75,if(A1="B-0002",1.95,0))))
=LOOKUP(A1,{"A001",1.5;"A002",1.55;"B001",1.75;"B002",1.95})或=LOOKUP(A1,{"A001","A002","B001","B002"},{1.5,1.55,1.75,1.95})
