您的位置首页百科问答

excel数据关联

excel数据关联

B1=lookup(A1,{"cut1","cut2","cut3"戚敬,"cut4","cut5"},{10,20,30,40,50})大括号高态慎中可设置许闭拦多,但两大括号内数量须一样多