Calling a specific range name in a formula from a list of range names

[Triedtwice]

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.

 

[StephenCrump]

Try: =INDEX(Employee,MATCH(F12,INDIRECT(A2),))

 

[Triedtwice]

Try: =INDEX(Employee,MATCH(F12,INDIRECT(A2),))

That worked perfectly! The more I learn the more I realize there is to learn! Thank you!!!

 

[smozgur]

That worked perfectly! The more I learn the more I realize there is to learn! Thank you!!!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.