Hi,

Is it feasible simply to insert a line above and apply index numbers to each
column? That way instead of hardcoding "3" you can have it point to a cell
reference and it will move relatively as you copy your formula across.

Cheers,
Jon

"Charles Woll" wrote:

I need to increment the Col_index_num as the formula is copied accross
the row.

=IF(VLOOKUP($A95,Score_Table,3)="","",VLOOKUP(A95, Score_Table,3))

So the 3 needs to be changed to a variable reference.

--
\\\|///
\\ ~ ~ //
( @ @ )
--oOOo-(_)-oOOo---
Charlie Woll