如何在Excel表格中将sheet1的数据引用到sheet2中

1、在sheet2的A3公式=IF(B3="","",ROW()-2) 2、在heet2的B3公式=IF(INDEX(Sheet1!H:H,SMALL(IF($B$1=Sheet1!B:B,ROW(Sheet1!A:A),3000),ROW(A1)))="","",INDEX(Sheet1!H:H,SMALL(IF($B$1=Sheet1!B:B,ROW(Sheet1!A:A),3000),ROW(A1))))，按Ctrl+