modification on my lookup formula

[alvbnp]

I am currently using this

=IF(ISNA(v(INDEX(sheet2!A:C,MATCH(B2,sheet2!A:A,0),3)))," ",v())

The formula match B2 with columnA in sheet2 and pick up the third column value in sheet2.

Now need modify it to match B2 with columnA and C2 with columnB in sheet2 then pick up the third column value in sheet2.

Meaning lookup if two criterias is matched.

Thanks.

 

[Aladin Akyurek]

I am currently using this

=IF(ISNA(v(INDEX(sheet2!A:C,MATCH(B2,sheet2!A:A,0),3)))," ",v())

The formula match B2 with columnA in sheet2 and pick up the third column value in sheet2.

Now need modify it to match B2 with columnA and C2 with columnB in sheet2 then pick up the third column value in sheet2.

Meaning lookup if two criterias is matched.

Thanks.

=IF(ISNA(V(INDEX(Sheet2!$C$2:$C$400,MATCH(1,IF(Sheet2!$A$2:$A$400=B2,IF(Sheet2!$B$2:$B$400=C2,1)),0)))),"",V())

which needs to be confirmed with control+shift+enter, not with enter.

Note that you can't reference whole columns like A:A in this type of formulas.