Hello! For some reason Excel isn't autofilling the formula for me. This is what I am using:

=VLOOKUP($A5,TEAM!$B:$MZ,23,FALSE)

When I select the cell formula extension button thing and drag it to the right, the formula copies exactly into the next cell. If I select multiple cells starting from 19-23 and then drag, excel just repeats the formula over, (19, 20, 21, 22, 23, 19, 20, 21, 22, 23, 19, 20...) This is seriously frustrating as I have to click into the formula bar on each cell and change the value of the column lookup.

I can't keep going manually as I need to go to about 300 cells...

Any ideas as to why this is happening and how to fix it?

Thanks!