If I choose a word/command/field from the drop down box,
how can I format the next cell over recognize this selection
and display a number?

Basically I created a drop down box, Van, Bus, etc...
When I choose Van, I would like the next cell over
to recognize this selection and show $80.


Many thanks and appreciate the help!

Rob