Auto Fill after selecting from a drop down box

[Toni54]

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

[dmang1]

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

[FDibbins]

your rage in your lookup only covers the 1st row of data, extend it down and you should be good to go

for something like that tho, it may have been simpler to use
=VLOOKUP(G6,Q6:S10,2,FALSE)

[Toni54]

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

[dmang1]

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