SHARE
TWEET

Untitled

a guest Jun 20th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =IF(Sheet1!C2="x", Sheet1!B2,"")
  2.      
  3. =IF(Sheet1!C2="x", Sheet1!B2,"what to replace here to not to add a blank cell")
  4.      
  5. =IFERROR(INDEX(Sheet1!$B$1:$B$15,SMALL(IF(Sheet1!$C$1:$C$15="x",ROW($B$1:$B$15)),ROW(1:1))),"")
  6.      
  7. =IF(Sheet1!C2="x", Sheet1!B2,"Doesn't Match")
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