Q:

How to select individual values from non-contiguous named range in Excel

I've created some named ranges on a spreadsheet which are built up from non-contiguous cells. 
For example I've created one called report:
=Report!$M2,Report!$Y2,Report!$AK2

I can select the first element of the named array with the following formula:
=index(report, 1)

But how do I select the second and third elements? 
I tried:
=index(report, 2) 

But it failed.  What have I failed to grasp? 

A:

You can access that area using the optional area_num parameter of the INDEX function.  It's the fourth parameter.  E.g.
=INDEX(report,,,2)

If that area contains more than one cell you can access the second element (for example) like this:
=INDEX(report,2,,2)

