Range name in formula

I want to use a named range in an index/match formula, but I want the range used to be determined by text in another cell. When the text in this other cell changes to another named range, the formula uses the new named range.

How would I go about doing that? The formula works splendidly with the range named specifically, but I need it to be dynamic.

Thanks.

Formulas and Functions

HansVogelaar
Jul 15, 2021
David2190 Let's say you enter the name in cell A1.

You can then use INDIRECT(A1) in your formulas to refer to the range whose name is in A1.

8 Replies

HansVogelaar
MVP
Jul 15, 2021
David2190 Let's say you enter the name in cell A1.

You can then use INDIRECT(A1) in your formulas to refer to the range whose name is in A1.
- PeterBartholomew1
  Silver Contributor
  Jul 15, 2021
  HansVogelaar
  There are situations in which multiple ranges can be 'lumped' together.
  - HansVogelaar
    MVP
    Jul 15, 2021
    PeterBartholomew1
    
    Hi Peter,
    
    I feel dense. I don't get your point.
- David2190
  Copper Contributor
  Jul 15, 2021
  INDIRECT!
  Of course you can.
  Thanks Hans.

Forum Discussion

Range name in formula

8 Replies

Resources