VLOOKUP with multiple critiera

[Memar]

[FONT=&quot]I want to use VLookup or another formula to get a desired data in red. I couln't get the result that I need using this formula=VLOOKUP(val1&val2,data,col_index,0)
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]

Column A	Column B	Column C	Column D
	Product Item NO
	D24162	D34162	D44162
JAN	Cell B3 DESIRED RESULT 15	10
FEB	Cell B4 DESIRED RESULT 20	20
MAR	Cell B5 DESIRED RESULT 50	5

<tbody class="SCXW170678635" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">
</tbody>

[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]

	D24162	D34162	D44162
JAN	15	10
FEB	20	20
MAR	50	5
APR	30	6

<tbody class="SCXW170678635" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">
</tbody>

[/FONT]
[FONT=&quot]
[/FONT]
Thank you for your help and time

 

[Ron Coderre]

using this example...
This structure is in A1:D5

	Product Item NO
	D24162	D34162	D44162
JAN
FEB
MAR

<tbody>
</tbody>

and this data set in A7:D11

	D24162	D34162	D44162
JAN	15	10
FEB	20	20
MAR	50	5
APR	30	6

<tbody>
</tbody>

This regular formula, copied across and down, returns the monthly totals for the matching ref nums:

B3: =SUMPRODUCT(($A$8:$A$11=$A3)*($B$7:$D$7=B$2)*$B$8:$D$11)

Is that something you can work with?

 

[Memar]

Thank you for the quick response. it gives me value error. The number in Cell B8 and D11 is a result from SUMIF formula.

 

[Aladin Akyurek]

Using VLOOKUP, we would get...

Row\Col	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​		Product​					D24162	D34162	D44162
2​		D24162	D34162	D44162		JAN	15​	10​
3​	JAN	15​	10​	0​		FEB	20​	20​
4​	FEB	20​	20​	0​		MAR	50​	5​
5​	MAR	50​	5​	0​		APR	30​	6​

<tbody>
</tbody>

B3, copied across to D3 and down:

=VLOOKUP($A3,$F:$I,MATCH(B$2,INDEX($F:$I,1,0),0),0)