|
Posted to microsoft.public.excel.misc
|
|
|
Lists
"Damien" wrote:
Okay, so i am an idiot. I need a cell reference not a value there. Thats why
that is happening. Thanks for your time. I think I am just going to play with
it for a while and try to figure this out.
"Gord Dibben" wrote:
VLOOKUP formulas will pull the data to appropriate cells.
See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.
http://www.contextures.on.ca/xlFunctions02.html
http://www.contextures.on.ca/xlDataVal01.html
Note the section on using DV lists from another worksheet by naming the list.
Gord Dibben MS Excel MVP
On Thu, 26 Jul 2007 09:08:04 -0700, Damien
wrote:
Situation:
I am trying to put together a price sheet for interior doors that I sell. I
am trying to make it easy for some of the staff here to do with out alot of
manipulation to the sheet. I would like to use lists, so they can simply
point and click on drop down menus to pick the options for the doors and then
the pricing will be available.
For Example:
I have a list thats ranges from C4:C7 that contains door styles. I would
like to have cells C27:C36 fill with prices depending upon which door style
is selected. I have a table made with all the pricing listed.
Question:
How do I link the information from the table to the cell range by selecting
an item in the list, or am I trying to do the impossible?
Thanks
Hi
|