Match with criteria

[KIM Chanthan]

Hi,

I want to use match formula with criteria.
Could you please help me on that?
Please see attached file for detail.

Thank for help,
Chanthan

 

[Hui]

In F2:
=IFERROR(MATCH(C2&D2,$A$2:$A$9&$B$2:$B$9,0),"Not found") Ctrl+Shift+Enter

Then copy down

 

[Ashhu]

this too works,

=INDEX(ROW($A$1:$D$9),MATCH(D2&C2,$B$2:$B$9&$A$2:$A$9,0),1)
Ctrl+Shift+Enter

 

[shrivallabha]

Normally entered.
=LOOKUP(2,FIND(C2&D2,$A$2:$A$9&$B$2:$B$9),ROW($C$2:$C$9))-1

 

[John Jairo V]

Hi to all!

Another options (No CSE):
=AGGREGATE(15,6,(ROW($B$2:$B$9)-1)/(C2&D2=$A$2:$A$9&$B$2:$B$9),1)
=SUMPRODUCT(--(C2&D2=$A$2:$A$9&$B$2:$B$9),ROW($B$2:$B$9)-1)
=LOOKUP(2,1/(C2&D2=$A$2:$A$9&$B$2:$B$9),ROW($B$2:$B$9)-1)
=MATCH(C2&D2,INDEX($A$2:$A$9&$B$2:$B$9,),)

Blessings!