Using Index with dynamic multiple columns

[Pher0ah]

Hi Community,

is there a way to get INDEX to work with multi-column select dynamically.

This Works: INDEX(Table,,{3,5,9})

This Throws an Error: INDEX(TABLE,,{COL_A,COL_D,COL_C})

EDIT:
Just an FYI; this also works: INDEX(TABLE,,COL_D)

 

[Fluff]

Hi & welcome to MrExcel.
What are COL_A, COL_D etc?

 

[Pher0ah]

Hi & welcome to MrExcel.
What are COL_A, COL_D etc?

Named lookups that evaluate to a number

=MATCH("Col Name",Sheet!1:1)

 

[Fluff]

In that case you cannot do that. The array needs to be hard values rather than variables or named ranges.
Have you got the CHOOSECOLS function yet?

 

[Pher0ah]

In that case you cannot do that. The array needs to be hard values rather than variables or named ranges.
Have you got the CHOOSECOLS function yet?

Nope not yet

 

[Fluff]

In that case I think your out of luck. I cannot think of any way to do what you want using named ranges.