Vlookup - Col_index_num

[Guest]

I do many Vlookups and I copy this formula over 20 columns. Can the
Col_Index_num increment automatically. Currently I have to modify each
cell.

 

[Pete_UK]

Depending on your formula (it's always a good idea to post a copy
here), you can make use of:

COLUMN(B1)

instead of 2, if you want to return data from the second column. As
you copy this across, this changes to COLUMN(C1), COLUMN(D1) etc, thus
returning 3, 4, 5 etc and so automatically increments the
col_index_num.

Hope this helps.

Pete