Triedtwice
New Member
- Joined
- Feb 17, 2014
- Messages
- 31
Is it possible, when writing a formula, to call a range name from a list of range names? For instance, I have a list of all my range names in cells A1:A7. The specific range name in cell A2 is "Sales_2018" (Sales_2018 refers to cells D12:D47). Now I want to create an index/match formula that inserts the "Sales_2018" name like this:
"=index(Employee,match(F12,=A2,0))" where A2 is, of course, the range name "Sales_2018"
My attempts to do this have not been successful.
"=index(Employee,match(F12,=A2,0))" where A2 is, of course, the range name "Sales_2018"
My attempts to do this have not been successful.