Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation drop down boxes, retreiving numbers
Heres the problem:
I have multiple steps to my drop down boxes. I'm using the data validation method of linking the boxes, but the last one i would like it to come up with a given price for my product, other than using a huge 'IF' statement, how can i use the information that was just selected in the drop down boxes to get me to that end price?? As an example if i had 5 car comapines, then each company has 5 models, and each model has 3 engine choices, how do i end up with the price for that specific make/model/engine??? My actaul use for spreadsheet has way more than just a few options under each box. Any help would be more than greatly appriciated!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation drop down boxes, retreiving numbers
I'm assuming you have a price table setup?
You don't need a huge IF formula but without knowing how your price table is setup it's impossible to make a specific suggestion. Biff "MDH" wrote in message ... Heres the problem: I have multiple steps to my drop down boxes. I'm using the data validation method of linking the boxes, but the last one i would like it to come up with a given price for my product, other than using a huge 'IF' statement, how can i use the information that was just selected in the drop down boxes to get me to that end price?? As an example if i had 5 car comapines, then each company has 5 models, and each model has 3 engine choices, how do i end up with the price for that specific make/model/engine??? My actaul use for spreadsheet has way more than just a few options under each box. Any help would be more than greatly appriciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
data validation | Excel Worksheet Functions | |||
Missing Drop Down list -Data Validation | Excel Discussion (Misc queries) | |||
data validation and drop down lists | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions |