Excel IF 函数，高分求助大神！！！

Question

=IF(B2=1,"上衣",IF(B2=2,"单裙",IF(B2=3,"西装",IF(B2=4,"背心",IF(B2=5,"裤子",IF(B2=6,"连衣裙",IF(B2=7,"T恤",IF(B2=8,"外套",IF(B2=9,"衬衣",IF(B2=D,"大衣",IF
(B2=F,"风衣",IF(B2=L,"棉褛",IF(B2=M,"毛衣",IF(B2=P,"皮衣",IF(B2=Q,"裘皮",IF(B2=Y,"羽绒"))))))))))))))))
做一个单元格内容判定，数字的都可以显示，但是字母的都显示不出来，那位大神能帮帮忙，或者给个很简单但能用的函数，谢谢！！！

Answer 1

字母要用引号括起来,公式可简化如下 =LOOKUP(B2,{1,"上衣";2,"单裙";3,"西装";4,"背心";5,"裤子";6,"连衣裙";7,"T恤";8,"外套";9,"衬衣";"D","大衣";"F","风衣";"L","棉褛";"M","毛衣";"P","皮衣";"Q","裘皮";"Y","羽绒"})

Answer 2

你真有功夫写啊，嵌套这么多IF，超出嵌套了吧，给个规则，你不是想我从里面一个一个找吧，不行给我发个表也行 251987289

在sheet2表中 A列B列分别列出
Y 羽绒
Q 裘皮
P 皮衣
M 毛衣
L 棉褛
F 风衣
D 大衣
9 衬衣
8 外套
7 T恤
6 连衣裙
5 裤子
4 背心
3 西装
2 单裙
1 上衣

然后在sheet1表中B2输入公式：=IFERROR(VLOOKUP(B2,Sheet2!A:B,2,FALSE),"")

Answer 3

公式太复杂，改下
=lookup(B2,{1,2,3,4,5,6,7,8,9,"D","F","L","M","P","Q","Y";"上衣","单裙","西装","背心","裤子","连衣裙","T恤","外套","衬衣","大衣","风衣","棉褛","毛衣","皮衣","裘皮","羽绒"})本回答被提问者采纳

Answer 4

对应在D列（随你方便，可选任意列）输入1、2、3、、、、9、D、F、、、Y，E列输入上衣、单裙、、、、；C2=VLLOKUP(B2，，2),下拉复制。
这就是将$D$2：$D$16做了一个基础数据。

Answer 5

字母要用引号括起来追问

还是不对啊？