假设第一个表在sheet1中，表二在sheet2中，型号A1在F列在F2中输入=if(and(g2=sheet1!b2,h2=sheet1!c2),"A1","")在F3中输入=if(and(g3=sheet1!b2,h3=sheet1!c2),"A1","")F4中输入=if(and(g4=sheet1!b2,h4=sheet1!c2),"A1","")其它型号的处理相同，如型号A2在E列，在E2中输入=if(and(g2=sheet1!b3,h2=sheet1!c3),"A2","")...
|
