拿单元格c1,d1来举例子,d1=(if(c1=a1,b1,if(c1=a2,b2,if(c1=a3,b3,if(c1=a4,b4,if(c1=a5,b5……………………………………))))))))))也就是说如果c1等于an,则d1=bn请问excel 有满足这个要求的公式没???