I have searched all over and can not find a thread that addresses my issue. If I missed it - please help and direct me to it. My issue is that someone helped me on this forum with the following formula which works great. However, I need to copy it down at least 200 rows. Problem is when I've copied it down - row 1 stays as row 1. I need that to increment +1 because right now I am going in and manually changing the formula I copied down. There has got to be a better way.

[I even learned about macros and tried Range("P1:P200").Formula = "=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))" but had the same problem. It copied 1 all the way down.]

Currently when copied - formula looks like this:
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))

Desired Result when copied - to look like this:
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,2,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,3,MATCH($B$1,Matrix!$1:$1,0))

Any help would be immensely appreciated.
Cindy