Excel如何自动填写对应单元格数据?答:其实很简单,在B1~K1分别输入:B1:=if(A1=0,0,"")C1:=if(A1=1,1,"")D1:=if(A1=2,2,"")E1:=if(A1=3,3,"")...K1:=if(A1=9,9,"")
Excel的 自动填写数据的功能答:这个很简单,只要用VLOOKUP函数就可以了,你把附件上传上来,我帮你弄~~你在B3单元格输入下面公式:=IF(ISERROR(VLOOKUP(B1,$A$2:$D$11,2,0)),"",VLOOKUP(B1,$A$2:$D$11,2,0)E3单元格输入:=IF(ISERROR(VLOOKUP(B1,$A$2:$D$11,2,0)),"",VLOOKUP(B1,$A$2:$D$11,3,0)B5...