I have a real simple worksheet that has a list box of 10 items. When I choose
one of the items from the list I want it to auto fill the next cell with a
amount.
If I pick $100 from the dropdown list, I want it to populate the next cell
with 15.
$100 - 15
$200 - 30
$300 - 45