=VLOOKUP(A1,{1," Pass ");2.”拒絕”;3,"待定" },2,0)
或輸入
= lookup (a1,{1,2,3},{ "通過","拒絕","待定" })
可以有任意數量的條件。