根据sheet4的A列来筛选本sheet中G列
方法一:
vlookup
=VLOOKUP(G2,Sheet4!A:A,1,0)
方法二:
ifcountif
=IF(COUNTIF(Sheet4!A:A,G2),TRUE, FALSE)
根据sheet4的A列来筛选本sheet中G列
方法一:
vlookup
=VLOOKUP(G2,Sheet4!A:A,1,0)
方法二:
ifcountif
=IF(COUNTIF(Sheet4!A:A,G2),TRUE, FALSE)