A5=IF($B$1"",VLOOKUP($B$1,Sheet2!$A:$H,COLUMN(A$1),0),IF($B$2"",INDEX(Sheet2!A:A,MATCH($B$2,Sheet2!$B:$B,)),""))A8=IF(AND($B$5="",COUNTIF(Sheet3!$A:$A,$B$5)<ROW(A1)),"",INDEX(Sheet3!A:A,SMALL(IF(Sheet3!$A$2:$A$11633=$B$5,ROW($A$2:$A$11633),4^8),ROW($A1))))...
|