After further investigation I now understand R1C1....if I change the R1C in the formula to R[0]C[-1] it will select the correct cell in the previous column. Thank you!