Lookup value into multiple lookup array

[mart_mrexcel]

is there a way to simplify the match() over match() function using IFerror() - see my formula

Book1
	A	B	C	D	E	F	G
1	Lookup VALUE				Lookup ARRAY
2	Employee Id	Local Indentifier	Result		Emp	Match
3	201838	10069	4		205941	205941
4	201839	10071	#N/A		205947	205947
5	201840	10076	6		205950	205950
6	202099	202099	#N/A		201838	10069
7	202125	10099	7		205957	205957
8	202285	202285	#N/A		201840	10076
9	202346	101560	#N/A		202125	10099
10					206021	206021
11
Sheet1

Cell Formulas
Range	Formula
C3:C9	C3	=IFERROR(MATCH(A3,$E$3:$E$10,0),IFERROR(MATCH(A3,$F$3:$F$10,0),IFERROR(MATCH(B3,$E$3:$E$10,0),MATCH(B3,$F$3:$F$10,0))))

 

[Legacy 143009]

One short hand could be:

=IFERROR(MATCH(1,((A3=$E$3,$E$10)+(A3=$F$3:$F$10))*((B3=$F$3:$F$10)+(B3=$E$3:$E$10)),0),"")

 

[kevin9999]

Another possibility...

Book1
	A	B	C	D	E	F
1	Lookup VALUE				Lookup ARRAY
2	Employee Id	Local Indentifier	Result		Emp	Match
3	201838	10069	4		205941	205941
4	201839	10071	Not found		205947	205947
5	201840	10076	6		205950	205950
6	202099	202099	Not found		201838	10069
7	202125	10099	7		205957	205957
8	202285	202285	Not found		201840	10076
9	202346	101560	Not found		202125	10099
10					206021	206021
11
Sheet1

Cell Formulas
Range	Formula
C3:C9	C3	=IF(SUMPRODUCT(($E$3:$F$10=A3)+($E$3:$F$10=B3))>0,SUMPRODUCT(($E$3:$F$10=A3)*ROW($E$3:$F$10))-2,"Not found")

 

[mart_mrexcel]

Thank you so much

 

[mart_mrexcel]

One short hand could be:

=IFERROR(MATCH(1,((A3=$E$3,$E$10)+(A3=$F$3:$F$10))*((B3=$F$3:$F$10)+(B3=$E$3:$E$10)),0),"")

Thank you so much

 

[kevin9999]

Thank you so much

You're welcome, and thanks for the feedback