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