Hi. I tried to help before, but I don't know if it's "valuable". I think
you're going about it the wrong way, though. You don't need all those named
ranges; just a couple. I'm not quite sure EXACTLY what you're looking for,
but I created a workbook I hope explains what I'm suggesting. You can
download it at http://www.myexpertsonline.com/freedls/pricelist.xls. There
are no macros in it.

Note the named ranges I used, and the ranges they cover. Note the data
validation in E10, and the vlookups in E12 and E14. Note that you can hide
the sheet called PriceList.

I hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"InfinityDesigns" wrote in
message ...
I am not sure what happened to my last thread. I was getting valuable
information from someone but my thread disappeared. What I am trying to
do
is this, If I type =HollywoodHills in K10 it returns a value from that
defined name of $34.56 which is the retail price of that product. I have
another defined name of "HollywoodHillsC" which will return the value of
$20.25 which is the wholesale price of the same product. The defined
names
will change with each product line on the form. So I want to be able to
type
=HollywoodHills in K10 have another cell say N10 that will not be visible
to
the user that will have the same name in it, and then use a formula or
macro
to add the letter "C" to the end of it to return the wholesale price of
whatever product is in K10. This other cell will not be visible by the
user
because some users should not have access to wholesale pricing. Can
anyone
help???