Forum Discussion
David2190
Jul 15, 2021Copper Contributor
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...
- 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.
ā
HansVogelaar
Jul 15, 2021MVP
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.
ā
David2190
Jul 15, 2021Copper Contributor
INDIRECT!
Of course you can.
Thanks Hans.
Of course you can.
Thanks Hans.