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.