Hi Robert,

your drop down box should refers to a cell, lets say H1 for eg.

create an auxiliar ID column in your table i.é.

A B C
1 ID Type $$
2 1 van $80
3 2 xxx xxx
4 3 xxx xxx

use a formula =vlookup(h1,a2:c4,3,false)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Robert Albrecht" escreveu:

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