You could use something like Vlookup().

Check out Debra Dalgleish's site:

http://www.contextures.com/xlFunctions02.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Robert Albrecht" <Robert wrote in
message ...
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