working with references of cells
 

How can I consider the value of a cell as a row's or column's reference of
the other cell?

Thanks,
Diana

Some thoughts to keep the ball rolling <g ..

Perhaps INDIRECT is what you're after ?

Suppose you have in B3: Tough

If you put in say, E3: =INDIRECT("B3")
E3 will return the contents in B3, i.e.: Tough

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Diana" wrote in message
...
How can I consider the value of a cell as a row's or column's reference of
the other cell?

Thanks,
Diana