Index Function Formula Using Criteria

[muhammad susanto]

hi all...
how to make formula for this case

rumus sum till.xlsx
	A	B	C	D
1			Sold	Free
2	CAR	this month	5	5
3		till to this month	8	6
4	BYCYCLE	this month	4	5
5		till to this month	5	6
6	BIRD	this month	10	1
7		till to this month	15	2
8	etc..
9		expected result
10		Car	this month	5
11			till to this month	8
12		etc…
Sheet1

Cell Formulas
Range	Formula
D10	D10	=C2

my target in cell D10 down and i want change using DV dropdown list in cell B10,,,,change suite with Bird or Bycycle...
anyhelp, thanks in advance
susanto

 

[Phuoc]

Book1
	A	B	C	D
1			Sold	Free
2	CAR	this month	5	5
3		till to this month	8	6
4	BYCYCLE	this month	4	5
5		till to this month	5	6
6	BIRD	this month	10	1
7		till to this month	15	2
8	etc..
9		expected result
10		Car	this month	5
11		Car	till to this month	8
12		etc…
Sheet1

Cell Formulas
Range	Formula
D10:D11	D10	=INDEX($C$2:$C$7,MATCH(B10,$A$2:$A$7,0)+MATCH(C10,$B$2:$B$3,0)-1)