Excel formula Index and Match doesn't update when dragging down

Question

I have the following formula

=INDEX($D$2:$D$300018,MATCH($AA$3,$O$2:$O$300018,0))

When I drag down the formula it doesn't change $AA$3 to corresponding Row

Please help

Remove the `$` in front of the 3. – BigBen Jun 25 '20 at 12:43 — BigBen, Jun 25 '20 at 12:43

score 1 · Answer 1 · answered Jun 25 '20 at 13:08

1

replace:

=INDEX($D$2:$D$300018,MATCH($AA$3,$O$2:$O$300018,0))

with:

=INDEX($D$2:$D$300018,MATCH($AA3,$O$2:$O$300018,0))

answered Jun 25 '20 at 13:08

Gary's Student

1 Answers1