Flexibility in Line Item options

[kmizzi]

Hello,

I am preparing a construction budget for some condos and I'd like to
have a simple way to choose between different options for some of the
line items (i.e. granite countertops instead of tile)... each would
have its own cost implication and affect the bottom line. Any ideas?

Thanks,
Kalvin Mizzi
Financial Analyst
Equity Directions, Inc.

 

[Bondi]

Hi Kalvin
If you make a data array with options and price as:

Data array:
Granite 3
Wood 4
Tile 5

You could use a validation list on the first column to make a dropdown
menu and then a VLOOKUP() on the table array to change the price on the
bottom line.

Regards
Bondi

 

[Bob Phillips]

This sounds good for Data Validation. Have columns for each option and a
dropdown that the option is chosen from. See
http://www.contextures.com/xlDataVal01.html for a starter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[kmizzi]

Awesome, thanks guys

 

[kmizzi]

Unfortunately neither of these methods work.

Here is the desire effect in more detal.

If there is a different price for the three options (as follows)

Granite 5
Plastic 4
Wood 2

If I choose plastic then the column to the right of it changes to 4...
but if i have a calculation that does the quantity times the price (5,4
or 2)... the price reference cell is fixed to either the 5, 4, or 2..
and does not change when the option changes. Any other ideas?

 

[Bob Phillips]

Do you mean it should show that behaviour, or what you tried does?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)