If you want to start with col index 2 then use Column(B1) as the index...
when you drag it to the next column it will change to Column(C1) and give you
3, and so on.

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Matt" wrote:

I'm copying a VLOOKUP formula across a number of columns. How do I make the
formula col_index_num automatically change to the corresponding column cell
as I drag?
--
Cheers
Matt