| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use result from some function as a part of cell reference?
If say cell C1 contains 24 then
=ADDRESS(C1,4,4,1) returns D24 cell reference. If you need the content (value) of cell D24 then use =INDIRECT(ADDRESS(C1,4,4,1)) Regards, Stefi €˛Piia€¯ ezt Ć*rta: Hi, In some cell I have a calculation giving some value as a result, let's say xx (e.g. 24) How do I use the results from this function as a number part of some other function's cell reference, i.e. =Dxx (e.g. D24) Thanks a lot! :) -Piia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can a function return part of it's result in italics? | Excel Worksheet Functions | |||
| use the result of match function as a part of row address | New Users to Excel | |||
| Using the result of formula as part of reference to a cell in form | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Using result from ADDRESS function as a cell reference itself | Excel Worksheet Functions | |||
Threaded Mode
