Specifying cell targets with text in cells
Specifying cell targets with text in cells
(OP)
This is probably a simple one because I've read bits and pieces of how it's done, but I can't seem to execute it. I've tried using the offset function for a similar effect, but the coding is not as simple as I hoped.
How do you use a cell input as the target location for a formula?
For example:
If I want my OUTPUT cell to find the maximum of B12:H12...
Can I use two input cells somewhere on the sheet to input "B12" and "H12", and then use those text references to define the range in the OUTPUT cell's formula?
The goal is to be able to target the range manually to allow more rapid updating of the sheet.
How do you use a cell input as the target location for a formula?
For example:
If I want my OUTPUT cell to find the maximum of B12:H12...
Can I use two input cells somewhere on the sheet to input "B12" and "H12", and then use those text references to define the range in the OUTPUT cell's formula?
The goal is to be able to target the range manually to allow more rapid updating of the sheet.
RE: Specifying cell targets with text in cells
CODE --> Excel
where cells k17 and L17 contain the beginning and end of the range required.
RE: Specifying cell targets with text in cells
where E1 contains B12
and E2 contains H12
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Specifying cell targets with text in cells