Formula depending on the selection from drop down menu

I am using Excel Web for this one. Basically I need calculate the price of the product depending on the type of material it is made off * metres(Metres are type in, while materials are drop down menu, each material have its own price).
Hopefully I explained myself properly.
Thanks,
Mark

Hello and welcome to the forum

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Originally Posted by mrkmvzn

please find photo attached

The request was for a sample workbook, not a pic - we cannot work with pics.

Also, there is nothing magical about a drop down (data validation), it acts in the exact same way as if you had entered the data manually, and excel formulas only see the data in the cell as if it had been entered manually.

The only real advantages of using a DD is that it saves typing, avoids typos/spelling mistakes, restricts entry to what you specify, and maybe saves a bit of time in entering data.
Other than that, no difference to manual entry

So, having said that, if you know how to reference a regular cell, you would reference the DD in the exact same way

Not sure where you want this, but try...
=INDEX($H$3:$H$11,MATCH(C2,$I$3:$I$11,0))*D2

or:

=SUMPRODUCT(($I$3:$I$11=C2)*$H$3:$H$11*D2)

Perhaps you entered it incorrectly, my suggestion gives the same answers as bebo's sumproduct...

	C	D	E	F	G
1	Medžiaga	Metrai	Savikaina	INDEX/MATCH	SUMPRODUCT
2	Veliuras	5	75	70	70
3	Veliuras	10		140	140
4	Veliuras(AR01403)	15		195	195
5	Veliuras(AR01403)	20		260	260
6	Kapronas	25		300	300
7	Kapronas	30		360	360
8	Kapronas	35		420	420
9	Šilkas	40		280	280
10	Linas	45		180	180
11	Blackout	50		1000	1000