vlookup
 

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

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

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

--

Regards,

Peo Sjoblom


"Charles Woll" wrote in message
...
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

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

"Charles Woll" wrote in message
...
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

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" wrote in message
...
Column(C:C) did not work, inserting a row to use for indexing did work.
Thank you, charlie

"Charles Woll" wrote in message
...
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

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

"Peo Sjoblom" wrote in message
...
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" wrote in message
...
Column(C:C) did not work, inserting a row to use for indexing did work.
Thank you, charlie

"Charles Woll" wrote in message
...
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