Hi

I have the following line of code - I intended for it to look at the whole of Today Intervals cols A:Q and look at the RTW Tracker 4 rows to the left, but it only looks at the corresponding row A:Q and 4 rows up in the same column - how can I fix these?

Cells(RowNumRTW, 5).Formula = "=INDEX('Today Intervals'!RC1:RC17,MATCH('RTW Tracker'!RC[-4],9,0),16)"
Also would it be possible to use a worksheet function here to save me saving this formula to a value in the next line?