excel求助！！！A列中有苹果，香蕉；白菜，青菜；桌子，凳子。

显示全部楼层 · 2011-8-25 13:41:52

凡是A列中提到苹果或香蕉，则B列显示：水果；凡是A列中提到白菜或青菜，则B列显示：蔬菜；凡是A列中提到桌子或凳子，则B列显示：家具；A列是其它的，B列显示：其它。如何做得到？

千问 · 2011-8-25 13:41:52

B1=if(or(A1="苹果",A1="香蕉"),"水果",if(or(A1="白菜",A1="青菜"),"蔬菜",if(or(A1="桌子",A1="凳子"),"家具",if(A1="其它","其它",""))))...

千问 · 2011-8-25 13:41:52

=LOOKUP(MATCH(A1,{"苹果","香蕉","白菜","青菜","桌子","凳子"},),{1,3,5},{"水果","蔬菜","家具"}) 或=LOOKUP(FIND(A1,"苹果香蕉白菜青菜桌子凳子"),{1,5,9},{"水果","蔬菜","家具"})...

千问 · 2011-8-25 13:41:52

用IF加公式...