I am trying to design an automobile purchase order form that uses option
codes and its corresponding prices. When I enter one option code on one
cell/row (i.e. LCB4 for Leather Upholstery), the cell next to it will
automatically kick out the correct price of $1450. However, another option
code (i.e. ZPP for an automobile Premium Package) at the price of $2900
includes Leather Upholstery. If ordered, I need to enter ZPP on another
cell/row that will generate the priceof $2900 next to ZPP; however, I do not
know how to get Excel to automatically recognize the ZPP code and change my
Leather Price of $1450 to $0 since it is included in the Premium Package.
Can anyone assist? Thanks again.
--
Erwin