vlookup - col_index_num "auto fill" when drag filling formula?

Hi all.

Here's the skinny.

I have a list of emails in column A. My table array is a list of contacts with the email also in column A.

My formula in cell B2 is:

=VLOOKUP($A2,'Sheet A'!$A:$O,2,FALSE)

Is there any way to have the column index number update such that when I drag-fill the formula into cell C2 it becomes "3" and so on? I have about 35 columns to fill in and don't want to have to manually update the col_index_num in each formula.

Thanks.

Try not using vlookup to begin with..
Use Index(Match instead...

=INDEX('Sheet A'!B:B,MATCH($A2,'Sheet A'!$A:$A,0))

The reference to B:B will incriment automatically as formula is dragged to the right.

Also, considering that you are pulling multiple column values based on the same match..
To significantly improve performance, put the match in it's own cell, and refer to that cell with INDEX

Say Z2 for example
Z2: =MATCH($A2,'Sheet A'!$A:$A,0)
Then use
=INDEX('Sheet A'!B:B,$Z2)

This way, the function of finding the match is only done once (in Z2) for the entire row of formulas.
Where with vlookup and INDEX(MATCH, the match is done for every single formula in the row.