Specifying cell targets with text in cells

skeletron · Mar 3, 2020

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 · Mar 4, 2020

something like this?

Code:

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

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

IRstuff · Mar 4, 2020

=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 · Mar 4, 2020

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Specifying cell targets with text in cells

skeletron

Structural

Agent666

Structural

IRstuff

Aerospace

skeletron

Structural

Similar threads

Part and Inventory Search

Sponsor