Hi,
I would like to make a quotation form in excel with separate rates for different items. I will explain how it will work and I wish you help me to do it.

Quotations for;
· Lambiri
· Doors
· Partitions
As you see on picture rates are different. For lambiri 20,000.00, for doors 40,000.00 for partition 70,000.00
In the Column G rate has been calculated manually. In G6 this formula works =D6*A3
In G7, =D7*B3
But for easy way I would like to formula different way to make it quick and be more professional.
In the Column E (ITEM) ; there is list menu “Lambiri – Door – Partition”
And as you see on top left corner what the RATES are.
Now my question is:
If I select an item from list menu, rate will be what ever in RATES shows.
For example;
If I select item from list menu “Partition” it will calculate result in to G8, C3*D8
Or if select item “Door” in same cell, it will calculate result in to cell, B3*D8
I wish you can help me to resolve this…

Thank you…