vlookup

[Charles Woll]

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

 

[Guest]

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

 

[Peo Sjoblom]

replace 3 with COLUMN(C:C) and copy accross

 

[Charles Woll]

Column(C:C) did not work, inserting a row to use for indexing did work.
Thank you, charlie

 

[Peo Sjoblom]

It works if you apply it correctly, obviously it won't work if you insert a
column
as opposed to copying it across

=COLUMN(C:C)

will return 3, if you copy it to the right it will return 4, 5 and so on

VLOOKUP($A95,Score_Table,COLUMN(C:C))

equals

VLOOKUP($A95,Score_Table,3)



Regards,

Peo Sjoblom

 

[Charles Woll]

You are absolutely correct... I must have made a syntax error.
Thanks, charlie