# VLOOKUP with extra criteria

#### fugeg70

##### Board Regular
Hi there,

I am working with the following formula;

=IF(VLOOKUP(Sheet1!AM6,Sheet2!\$B:\$M,3,FALSE)=\$A\$17,(VLOOKUP(Sheet1!AM6,Sheet2!\$B:\$M,10,FALSE)),0)

However, I wish to expand this to make it have to equal A17 and another cell, for example lets use D2, in order to move onto the second look up.

Can anyone help ?

Thankyou,

Graham.

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### texasalynn

##### Well-known Member
You mean something like this?

=IF(and(VLOOKUP(Sheet1!AM6,Sheet2!\$B:\$M,3,FALSE)=\$A\$17,VLOOKUP
(Sheet1!AM6,Sheet2!\$B:\$M,3,FALSE)=\$D\$2),(VLOOKUP(Sheet1!AM6,Sheet2!\$B:\$M,10,FALSE)),0)

HTH
texasalynn

#### fairwinds

##### MrExcel MVP
=IF(\$A\$17=\$D\$2,IF(VLOOKUP(Sheet1!AM6,Sheet2!\$B:\$M,3,FALSE)=\$A\$17,(VLOOKUP(Sheet1!AM6,Sheet2!\$B:\$M,10,FALSE)),0),0)

Replies
1
Views
148
Replies
0
Views
193
Replies
0
Views
271
Replies
2
Views
540
Replies
3
Views
274

1,186,371
Messages
5,957,473
Members
438,307
Latest member
bigmike1720

### 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