Auto Fill after selecting from a drop down box

Hey Guys,

I really need some help,

I have created a spreadsheet with a drop down box,

The drop down box selections are;
- 8T
- 13T
- Tipper
- Borer
- Fuel

the next column over is price, I want to put a code in there so when it selects 8T a certain cost has come up, I have that sorted, but in in the same cell, i need to have the cost change if 13T is selected

Can someone help me out?

I have attached the spreadsheet if it helps.

Thanks

Hello Toni,

I would use the following formula

=VLOOKUP(G6,$Q$6:$S$10,2,FALSE)

but remember to sort your lookup values by machine type ie column S.

Let me know how you go!

Cheers,
Diana

Excellent,

Thanks guys!!

So just one more thing now I think of it,

With the quantity and total cells,

what code do I use to have it automatically calculate the total price

So basically the equipment is 8T and the Price is 1300 and the quantity is 2, how do I get the total price cell to calculate automatically to say 2600?

I have attached the example if I am not being clear

Thanks for all your help

Hello Toni,

Firstly, you won't be able to use the data in column S as it is because Excel doesn't recognise the amount as a value as you also have text in the cell.
If column S was just numbers you could use the following formula =SUMPRODUCT(J6:K24,L6:M24).

Diana