Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to get cell references
I have a value in a particular cell and I need to return the cell reference
of that particular cell eg. "A23". What is the function for getting it. Thanks in advance Joseph |
#2
|
|||
|
|||
If cell A23 has a value that you want to use elsewhere then use
=A23 But if A23 has a text string in it like "Z99" that you want, then use =INDIRECT($A$23) -- Gary's Student "Joseph" wrote: I have a value in a particular cell and I need to return the cell reference of that particular cell eg. "A23". What is the function for getting it. Thanks in advance Joseph |
#3
|
|||
|
|||
Try =CELL("address",B3) where B3 is the cell you want the address for This will produce $B$3 as the result. -- SuperDave ------------------------------------------------------------------------ SuperDave's Profile: http://www.excelforum.com/member.php...o&userid=25935 View this thread: http://www.excelforum.com/showthread...hreadid=393272 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixed cell references | Excel Discussion (Misc queries) | |||
Absolute References in cell formula | Excel Worksheet Functions | |||
How to use complex no. functions that have cell references? | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) |