vlookup help:When I drag the formula

I have my lookup value in column A. The vlookup result in Column B.

=VLOOKUP(A1,ALL!B2:Y10482,2,FALSE)

I now want to drag this across to populate and return values up to column Y.

When I drag the formula or copy it to Column C it does this:

=VLOOKUP(B1,ALL!C2:Z10482,2,FALSE)

The lookup value, table array, and column index number have now changed to column B, C:Z, and 2, when I need it to increment like this:

=VLOOKUP(A1,ALL!B2:Y10482,3,FALSE)

The only thing I want to change as I paste it into the adjacent field is the col_index_number.

Is there a way to do this horizontally without manually changing the formula 26 times?