Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying cell references next to embedded cells in Word 2000 | New Users to Excel | |||
Excel cell references to 2nd worksheet stopped working | Excel Worksheet Functions | |||
Computations involving text cells are not working?? | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Excel-value in a range of cells for two cross references | Excel Worksheet Functions |