Named Ranges query

I'm thinking this isn't possible... but..

Can you enter a named range from a cell value?

i.e.

Please Login or Register  to view this content.

Where DataA,CodeA and Cust are named ranges on another sheet.

Can I enter "DataA" in Cell A1, and "CodeA" in cell A2... to make the index read:

Please Login or Register  to view this content.

Obviously you cant do that as it will look in cells A1 and A2 instead of reading the text and going to that named range. But does anyone know if this is possible or another way?

The reason being I have a ~2000 lines of repeating data, and a different sheet that summarizes every 40 lines or so with Index lookups. If I could do something like this, I only need to enter the A1 and A2 values on each sheet and all my index formulas would be the same. Otherwise I'll have to change them each time, i.e. DataB, CodeB, DataC, CodeB in each row in each sheet!

Try the INDIRECT function, replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

etc

Originally Posted by StephenR

Try the INDIRECT function, replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

etc

That's the one I'm after. Thanks for the help!!

I will make this model pretty and dynamic.. I will.. I will.. I will!!!