What i have is 6 "tables" that have data generated from another worksheet. I was trying to come up with some sort of formula to do the following:
if there is data in row 14, then row 15 needs to have "left", "right", "left", "right" in the corresponding cells. But my formulas don't work.
my formula that i was testing was
=IF(E15="left","right",IF(F14<>"","left",""))
This works to a point, but it won't skip over blanks and puts "right" in cells that follow a "left" cell. and all the data cells have "left" corresponding to them.
VBA at this point may be beneficial as i have several worksheets that are setup this way.

the data goes from column f:as.
any help is appreciated.