Referencing a named range from a cell

[lbird2]

I think this is an easy one.

Say I have three named ranges; one, two, three. Cell A1 contains one of these three based on condition from elsewhere. How can I use the contents of A1 as a named range in a formula? For example, if A1="two", lookup (C7, A1, 3, FALSE) would evaluate as (C7, two, 3, FALSE).

 

[Joe4]

To reference ranges "indirectly" like that, you would use the INDIRECT function, i.e.

=VLOOKUP(C7,INDIRECT(A1),3,FALSE)

 

[Fluff]

If you only have a few, you can use switch like

=VLOOKUP(C7,SWITCH(A1,"one",one,"two",Two,"three", three),3,0)

 

[lbird2]

Both worked brilliantly. Thank you so much.

 

[Fluff]

Glad we could help & thanks for the feedback.