Need help with formula from dropdown list

[hyruleramone]

Hi,

I have a dropdown list in cell A1/A2:

A2
refund

A3
no refund

Now, refund/no refund have a value in I1/I2:

I1
4000

I2
5000

I want to be able to multiple a quantity (it will be in cell B2) by the selection of the dropdown list, for instance:

If i select refund, i want to have a formula that can give me 4000* the value in B1 but if i select no refund from the dropdown list i want the formula to give 5000* the value in B1?

Dropdown list multiplication.xlsx
	A	B	C	D	E	F	G	H	I
1	Selection	QTY	Total					Refund	4000
2	Refund		0					No Refund	5000
3	No Refund		0
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=B2*I1

Cells with Data Validation
Cell	Allow	Criteria
A2:B3	List	=$H$1:$H$2

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H	I
1	Selection	QTY	Total					Refund	4000
2	Refund	4	16000					No Refund	5000
3	No Refund	2	10000
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=VLOOKUP(A2,$H$1:$I$2,2,0)*B2

 

[hyruleramone]

you are a genious! Thank you so much

 

[AhoyNC]

You're welcome. Thanks for the feedback.