# Vlookup where rows and coumn crteria meet

##### Board Regular
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?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Andrew Poulsom

##### MrExcel MVP
Formula in G2 copied down:

Excel 2010
ABCDEFG
1Product CodeWH CodeAccepted QtyProduct CodeWH CodeAccepted Qty
2111-00003DELHI873111-00003Kolkata995
3111-00003Kolkata995111-00003Delhi873
4111-00002Kolkata268
5111-00002Delhi108
6111-00003Pune925
Sheet1
Cell Formulas
RangeFormula
G2=INDEX(C\$2:C\$6,MATCH(1,INDEX((A\$2:A\$6=E2)*(B\$2:B\$6=F2),),FALSE))

##### Board Regular
Thanks a lot Andrew!!

Replies
12
Views
585
Replies
1
Views
515
Replies
6
Views
416
Replies
1
Views
330
Replies
6
Views
731

1,191,025
Messages
5,984,198
Members
439,877
Latest member
kellylet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back