need value from referenced cell
 

How do I:

cell 1: lookup value

cell 2: vlookup function

table: 2nd col cell addresses


I need cell 2 to display the cell contents of the cell address found in the table.

How?

J

need value from referenced cell
 

Try the question again but being less terse.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"J" wrote in message
...
How do I:

cell 1: lookup value

cell 2: vlookup function

table: 2nd col cell addresses


I need cell 2 to display the cell contents of the cell address found in
the table.

How?

J

need value from referenced cell
 

Tuesday Morn

I can use this solution:

I have changed the cell addresses in the table to equal the values of the referenced cells, instead of just the cells addresses.

Not what I wanted. but it will work for now.


"J" wrote in message ...
How do I:

cell 1: lookup value

cell 2: vlookup function

table: 2nd col cell addresses


I need cell 2 to display the cell contents of the cell address found in the table.

How?

J