auto populating a cell based on another cell for an invoice

G

Guest

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.
 
I

Ian

You need your data in a range of cells eg in column F you have Car, Truck
etc and the corresponding costs in column G.
Then in C2 you have =VLOOKUP(B2,F1:G5,2,FALSE)

Change the ranges to suit.

Ian
 
G

Guest

Thanks Ian that answers it.

Ian said:
You need your data in a range of cells eg in column F you have Car, Truck
etc and the corresponding costs in column G.
Then in C2 you have =VLOOKUP(B2,F1:G5,2,FALSE)

Change the ranges to suit.

Ian
Click to expand...
 
G

Gord Dibben

In C2 enter

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate cell 3
Conditional listbox cell populating 4
How to Auto-populate cell based on selection of a list item 2
Populate cell is another cell is populated 2
Excel 2003 - Drop Down list based on another cell value 3
auto populate cell based on previous cell drop down list selectio. 2
auto population based on single cell entry 8
Auto Fill Cell Based on Data in a different cell 4

Top