I want to do exactly what the guy posted in

http://www.myonlinetraininghub.com/e...ependent-lists

My problem now is the names I would have use involve numbers and more than 1 word.
I cannot name my ranges with numbers or more than 1 word, so INDIRECT is not working for me as he has it shown.
I would remove the numbers and consolidate the words but they are kind of pointless and look stupid without them.
For example:
1st BCT
127 ASB
and so on....

They are names for things already so my ranges names are a little weird so as not to include the numbers and such as you can probably tell from my formula that looks like gibberish.

But yes that is EXACTLY what I am looking to accomplish.

As stated in my first post, I have the formula to do it, but it is too long. Is there a way that I can put the formula in the worksheet and reference back to the FORMULA and not it's VALUE. Like i want the cell to hold the formula but not solve it.

Sorry to be so much of a pain but I don't want to go the tacky route and put all the values of column be available unless they make sense to be there.