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