In C2 enter

=LOOKUP(B2,{"Car","Plane","Ship","Truck"},{10,30,4 0,20})


Gord Dibben MS Excel MVP

On Thu, 8 Nov 2007 08:51:01 -0800, Chrisinct
wrote:

I need to auto populate a cell for an invoice based on another cell that is
populated from a list.

Example- B@ = a list consisting of the following Car, Truck, Plane, Ship
A car costs $10, a truck $20, a Plane $30 and a Ship $40. A is the number
of items described in B.

When I pick Car from the dropdown list to populate B2 I want C2 to populate
with $10 so that it can be multiplied by the number of items from A2 to give
me a total dollar amount in D2.

I appreciate any assistance you can give.