Index Match formula Loop

[jwburritt]

Hello: I have the following formula that I need to replicate down a column. When I paste it, it works fine. But when I try to put it into a loop, I can't seem to make it work. The failing loop is below.

Thanks!

The Formula: =Cells(i, 5).Formula = "=INDEX('Temp A'!$E$7:$E$19,MATCH(Current!D7,'Temp A'!$D$7:$D$19,0))"

For i = 1 to 10[INDENT]Cells(i, 5).Formula = "=INDEX('Temp A'!$E$7:$E$19,MATCH(Current!" & Cells(i, 4) & ",'Temp A'!$D$7:$D$19,0))" ' runtime error 1004[/INDENT]

Next i

 

[MARK858]

Maybe you mean...

Cells(i, 5).Formula = "=INDEX('Temp A'!$E$7:$E$19,MATCH(Current!" & Cells(i, 4).Address & ",'Temp A'!$D$7:$D$19,0))"

 

[jwburritt]

duh! Thanks Mark!