Hi

Column A has a list of values, we will use:

orange
Blue
Red
Yellow

Column B is automatically populated with the $ value based on the selection choosen in Column A:

orange $20
Blue $50
etc etc

This will ensure what the administrator typing up the proposal, if they choose Orange, the cost will automatically populate in next column, so we don't accidentally charge a client for the blue cost if orange is selected.

Does this help?