Help with quoting system

**Lubby** · 06-08-2012, 10:18 AM

Hey all,

We have used excel in our home building business for years to help us price out the cost of a house for a customer. However I am redeveloping our pricing system and would like to make it a bit more user friendly.

My thought is to be able to create a drop down list that when a user selects an item it then adds the value to the next cell.

ie: We have 3 different options for a kitchen sink. Kitchen sink A is worth $100, sink B is worth $200, and C is worth $300. We would then have a "quantity" cell, a drop down list where we select our sink, and it then totals that based on the value of the sink, in the next column.

I have figured out how to create a down down list, however I do not know how to create the "value" of that option so it can then be added to my final total.

Any help would be greatly appreciated!

Greg

**vandan_tanna** · 06-08-2012, 10:22 AM

I am assuming you will have a table with item description and its price somewhere. If so, you can use vlookup function to lookup the price.

**Lubby** · 06-08-2012, 01:38 PM

Do you have an example or tutorial of how to do this?

**vandan_tanna** · 06-08-2012, 03:10 PM

Google suggested this: http://spreadsheets.about.com/od/exc...320vlookup.htm

If youwant, you can upload your spreadsheet (with mock data if needed) and we can help you.

**ben_hensel** · 06-08-2012, 03:47 PM

Originally Posted by Lubby

Do you have an example or tutorial of how to do this?

I always start my "understanding excel" endeavors by getting it straight from the horses' mouth:
office.microsoft.com
The "description => syntax => remarks => examples" format they follow is like a dictionary for using excel functions. Even if I thought I understood things, even now, careful readings can surprise me with subtleties I hadn't noticed.

Here's the support page for VLOOKUP.