excel公式,请高手解答,在线等!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

在G2输入: =if(countif(数据库!$a:$a,$f2),vlookup($f2,数据库!$a:$e,column(b:b),),"") 右拉下拉填充