Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {=IFERROR(INDEX(Sheet2!$C$2:$C$8,MATCH(1,(A$10=Sheet2!$A$2:$A$8)*(B$10=Sheet2!$B$2:$B$8),0)),"")}
- {=IFERROR(INDEX(Sheet2!$C$2:$C$8, SMALL(IF(COUNTIF($A$15, Sheet2!$A$2:$A$8)*COUNTIF($B$15, Sheet2!$B$2:$B$8), ROW(Sheet2!$A$2:$A$8)-MIN(ROW(Sheet2!$A$2:$A$8))+1), ROW(A1)), COLUMN(A1)),"")}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement