Advertisement
NonplayerCharacter

Spreadsheets | Grab left cell if cell X has value

May 2nd, 2019
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // If cellX has value, grab the contents of the cell immediately to the left
  2. // RC[-1] is what takes the left cell
  3. // cellX can be an expression like REGEXMATCH
  4. =IF(cellX,INDIRECT("RC[-1]",0),"")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement