Cell Reference Names

[Guest]

Sorry to bother you guys but i need a hand

I have got a costing sheet with validation pulldown menu's (items) and in the next column there are prices.
The way i have been doing it is calling the price list cell for example "Red" and when i pull down and validate RED in the next column i have =indirect(RED) which works well i think anyway
But some of the item names are two or more words so i cannot reference properly and therfore i cannot get the price to lookup properly.

I am sorry if i have confused you but i am confused myself.

Thanks in advance

 

[Frank Kabel]

Hi
could you post an example of your data (plain text - no attachment
please). Don't think INDIRECT is the correct function. Sounds more
lkike VLOOKUP

 

[Dave Peterson]

I like what Frank wrote--a formula like this in the cell adjacent to your
data|validation cell:

=if(a1="","",vlookup(a1,sheet2!$a:$b,2,false))

If you put your table of items/prices in sheet2 in columns A:B.

====
I wouldn't use this in your example, but you may want to see how Debra Dalgleish
handles those values with spaces:

http://www.contextures.com/xlDataVal02.html#TwoWord

(Maybe for future consideration.)