VBA of Match Formula using R1C1

[who am i]

Hello and thank you everyone!

I am stumped how to write vba to place a r1c1 index match formula in a column. The match formula would always reference the 1st row. It is R1C1 because the index references a variable. Thanks again! I welcome questions.

    .Range(.Cells(2, DOWN_PAYMENT), .Cells(Range("a" & Rows.Count).End(xlUp).Row, DOWN_PAYMENT)).Formula2R1C1 = "=INDEX(C[" & 1 + (0 - DOWN_PAYMENT) & "]:C,row(RC),1)"

 

[who am i]

Above is the current formula I have, but I want the column reference of the index formula to be match("Material",1:1,0) but I cant figure out how to write R1C1 that would reference the same row.

 

[who am i]

Nevermind lol. I thought R1 meant 1 after the current row. Solution

.Range(.Cells(2, DOWN_PAYMENT), .Cells(Range("a" & Rows.Count).End(xlUp).Row, DOWN_PAYMENT)).Formula2R1C1 = "=INDEX(C[" & 1 + (0 - DOWN_PAYMENT) & "]:C,row(RC),match(""Material"",(R1),0))"