index match not working with CTRL-R?

[lost_in_the_sauce]

Maybe it's too early and I haven't had enough coffee but I'm just looking at this and wondering what I'm missing that's easy.

=INDEX(Sheet4!$C$2:$N$45,MATCH(Sheet3!$A$2,Sheet4!$A$2:$A$45,0),1)

value array is C2:N45 on sheet 4, lookup value is column A on sheet 3, match column is column A on sheet 4, works totally fine for the first column, but when I paste with CTRL-R (1st column is Jan, need to fill for the entire year), I just get the results from column 1 in all columns. Google, you've helped zero with this.

 

[Fluff]

How about

=INDEX(Sheet4!C$2:C$45,MATCH($A$2,Sheet4!$A$2:$A$45,0))

and drag to the right.

 

[lost_in_the_sauce]

How about

=INDEX(Sheet4!C$2:C$45,MATCH($A$2,Sheet4!$A$2:$A$45,0))

and drag to the right.

Yep, swapping the index from C2:N45 to C2:C45 fixed it. I need to go look at why

 

[Fluff]

You're welcome & thanks for the feedback.