Look at VLOOKUP with a table containing Van, Bus etc with corresponding values

=VLOOKUP("box value",Sheets2!A;B,2,0) where Sheets contains the table in
columns A& B. "box value" is Bus, Van etc

HTH

"Robert Albrecht" wrote:

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