Specifying cell targets with text in cells

[skeletron]

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.

 

[Agent666]

something like this?

=MAX(INDIRECT(K17):INDIRECT(L17))

where cells k17 and L17 contain the beginning and end of the range required.

 

[IRstuff]

=MAX(INDIRECT(E1):INDIRECT(E2))

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 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[skeletron]

Ahhh! Yes the Indirect function. Okay. Gonna give it a shot. Thanks guys!