Question

EXCEL中,当A1=X,则B1=0,当A1=C,则B1=1,当A1=V,则B1=2,当A1=B,则B1=3,当A1=N

Answer 1

=match(a1,{"X","C","V","B","N","M"},)-1

=FIND(A1,"XCVBNM")-1

对问题补充的回答.

首先要有一个对照表,假如对照表在Sheet2的A,B列,可以输入公式

=VLOOKUP(A1,Sheet2!A:B,2,)

假如没有这个对照表,则公式可以是

=VLOOKUP(A1,{"货物","仓库";"帽子","一仓库";"衣服","二、三仓库";"裤子","一仓库";"手套","二、四仓库";"袜子","三仓库";"鞋子","三仓库"},2,)