VLOOKUP with extra criteria

[fugeg70]

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.

 

[texasalynn]

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]

=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)