Vlookup where rows and coumn crteria meet

[niladri2005]

Hi All,

I have two sheets. In first sheet I have

Product Code <colgroup><col width="71"></colgroup><tbody> </tbody>	WH Code <tbody> </tbody>	Accepted Qty <colgroup><col width="64"></colgroup><tbody> </tbody>
111-00003 <colgroup><col width="93"></colgroup><tbody> </tbody>	DELHI <colgroup><col width="64"></colgroup><tbody> </tbody>	873 <colgroup><col width="64"></colgroup><tbody> </tbody>
111-00003	Kolkata	995
111-00002	Kolkata	268
111-00002	Delhi	108
111-00003	Pune	925

<tbody>
</tbody>

In another sheet

Product Code	WH Code	Accepted Qty
111-00003	Kolkata	??
111-00003	Delhi	??

<tbody>
</tbody>

Can you please suggest how will I get the result of Accepted Qty in sheet2?

 

[Andrew Poulsom]

Formula in G2 copied down:

Excel 2010
	A	B	C	D	E	F	G
1	Product Code	WH Code	Accepted Qty		Product Code	WH Code	Accepted Qty
2	111-00003	DELHI	873		111-00003	Kolkata	995
3	111-00003	Kolkata	995		111-00003	Delhi	873
4	111-00002	Kolkata	268
5	111-00002	Delhi	108
6	111-00003	Pune	925
Sheet1

Cell Formulas
Range	Formula
G2	=INDEX(C$2:C$6,MATCH(1,INDEX((A$2:A$6=E2)*(B$2:B$6=F2),),FALSE))

 

[niladri2005]

Thanks a lot Andrew!!