How to Refence Multi-Area Named Ranges

[brownwatercat]

If I have a Named-Range that has multiple areas, such as ...

TempRange =Sheet1!$C$2:$C$4,Sheet1!$X$2:$X$4
​

And I want to get the 2nd Value in the 2nd Area, in this case ...

Sheet1!$X3
​

Using the Named Range, How do I reference that cell in regular Excel formulas?

 

[Marcelo Branco]

Maybe using INDEX with the fourth parameter (area_num) as 2 - something like this
=INDEX(TempRange,2,1,2)

Hope this helps

M.

 

[brownwatercat]

Perfect! Thank You Marcelo.

 

[Marcelo Branco]

You are welcome. Glad to help

M.