Nested IF inside MATCH, INDEX

[sathishrosario]

Kindly Suggest me

=INDEX(D3:D6,MATCH(B2,IF(C3:C6=C2,B3:B6),0)) --- Working

=INDEX(D3:D6,MATCH(B2,IF(AND((C3:C6=C2),(E3:E6=E2)),B3:B6),0)) ---- Not Working

Thanks

 

[Domenic]

Try...

=INDEX(D3:D6,MATCH(B2,IF(C3:C6=C2,IF(E3:E6=E2,B3:B6)),0))

Or, preferably...

=INDEX(D3:D6,MATCH(1,IF(C3:C6=C2,IF(E3:E6=E2,IF(B3:B6=B2,1))),0))

...both confirmed with CONTROL+SHIFT+ENTER.

 

[sathishrosario]

Thanks Domenic...

I myself tried and found the same today. so we are in right track.

once again thanks

 

[Domenic]

You're welcome! Thanks for the feedback!