SHARE
TWEET

Untitled

a guest Jun 25th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. {=IFERROR(INDEX(Sheet2!$C$2:$C$8,MATCH(1,(A$10=Sheet2!$A$2:$A$8)*(B$10=Sheet2!$B$2:$B$8),0)),"")}
  2.      
  3. {=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)),"")}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top