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