excel输入1显示A 输入2显示B 输入3显示C

如图效果。在B1输入公式： =LOOKUP(A1,{1,2,3,4,12},{"张三","李四","赵六","王五"})就可以了