// 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),"")