Accessing a named range

%3CLINGO-SUB%20id%3D%22lingo-sub-2722109%22%20slang%3D%22en-US%22%3EAccessing%20a%20named%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722109%22%20slang%3D%22en-US%22%3EI%20can%20access%20the%20array%20if%20it's%20a1%2Ca2%2Ca3%2Ca4%20as%20but%20when%20if%20I%20create%20the%20named%20range%20a1%2Cc4%2Cd5%2Ce1%20it%20counts%20the%20correct%20number%20but%20not%20but%20can't%20call%20it%2C%20the%20first%20example%20works%20using%20%3Dindex(namerangename%2C2)%20but%20not%20the%20other%20%3Dindex(namerangename%2C%2C2)%20as%20column%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2722109%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2722141%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20a%20named%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722141%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1147286%22%20target%3D%22_blank%22%3E%40SWANNY1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20alternative%20syntax%20for%20INDEX%3A%3C%2FP%3E%0A%3CP%3E%3DINDEX(%3CEM%3Earray%2C%20%5Brow_number%5D%2C%20%5Bcolumn_number%5D%2C%20area%20number%3C%2FEM%3E)%3C%2FP%3E%0A%3CP%3EIn%20your%20example%3A%3C%2FP%3E%0A%3CP%3E%3DINDEX(namerangename%2C%20%2C%20%2C%202)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2722239%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20a%20named%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722239%22%20slang%3D%22en-US%22%3EAwesome%20thanks%2C%20not%20sure%20why%20I%20didn't%20try%20the%20area%2C%20it%20worked!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2722410%22%20slang%3D%22en-US%22%3ERe%3A%20Accessing%20a%20named%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722410%22%20slang%3D%22en-US%22%3EAnd%3CBR%20%2F%3E%3D%20INDEX(namedRange%2C1%2C1%2C%7B1%2C2%2C3%2C4%7D)%3CBR%20%2F%3Ewill%20place%20all%20the%20little%20ducks%20back%20in%20a%20row!%3C%2FLINGO-BODY%3E
New 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

@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!