Hi,

I have a Match and Index setup in cell a1 that works fine when it's
referring to one rangename that I enter as the first argument [the "array"
argument].

The objective is that the first argument of this INDEX function needs to
refer to multiple range names.

So I set up a Data Validation drop-down in cell B1 that represents each of
the dozen or so range names the function needs to refer to.

But it's returning a #ref#. ** Disregard the Match arguments in the
following example ..
cell a1: =Index(b1,match1,match1)
cell b1: A drop-down of range names ie "route1" / "route2" / "route3" / etc.

It returns a #ref# , #value#, or #name# error depening on how I attempt to
fix the problem, ie =Index(text(b1,"text"), match1, match2).

Does anyone know how to get the Index function to accept whatever's in the
drop-down?

Thanx in advance,
- Mike