SOLVED

Accessing a named range

Copper Contributor
I can access the array if it's a1,a2,a3,a4 as but when if I create the named range a1,c4,d5,e1 it counts the correct number but not but can't call it, the first example works using =index(namerangename,2) but not the other =index(namerangename,,2) as column
3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@SWANNY1010 

You can use the alternative syntax for INDEX:

=INDEX(array, [row_number], [column_number], area number)

In your example:

=INDEX(namerangename, , , 2)

Awesome thanks, not sure why I didn't try the area, it worked!

:)
And
= INDEX(namedRange,1,1,{1,2,3,4})
will place all the little ducks back in a row!
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@SWANNY1010 

You can use the alternative syntax for INDEX:

=INDEX(array, [row_number], [column_number], area number)

In your example:

=INDEX(namerangename, , , 2)

View solution in original post