Forum Discussion

David2190's avatar
David2190
Copper Contributor
Jul 15, 2021
Solved

Range name in formula

Hi 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 for...
  • HansVogelaar's avatar
    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.

     

    ā€ƒ

Resources