INDEX with IF and MATCH

[Markup123]

How do I modify this formula to return "YES" if there is a Match between the ranges in two different worksheets and return a 'blank' if there is no Match?
=INDEX(Worksheet2!$A:$AG,IF(ISNUMBER(MATCH('Worksheet1'!$A406,Worksheet 2!$A:$A,0)),"X",""))

 

[kevin9999]

Book1
	A	B
1	Yes
2
Sheet3

Cell Formulas
Range	Formula
A1	A1	=IFERROR(IF(INDEX(Worksheet2!$A:$A,MATCH(Worksheet1!$A$406,Worksheet2!$A:$A,0))>0,"Yes",),"")

Book1
	A	B
405
406	test value
407
Worksheet1

Book1
	A
1	nothing
2	nothing
3	nothing
4	nothing
5	nothing
6	123
7	test value
8	nothing
9	nothing
10	nothing
11	nothing
12
Worksheet2

 

[Markup123]

Book1
	A	B
1	Yes
2
Sheet3

Cell Formulas
Range	Formula
A1	A1	=IFERROR(IF(INDEX(Worksheet2!$A:$A,MATCH(Worksheet1!$A$406,Worksheet2!$A:$A,0))>0,"Yes",),"")

Book1
	A	B
405
406	test value
407
Worksheet1

Book1
	A
1	nothing
2	nothing
3	nothing
4	nothing
5	nothing
6	123
7	test value
8	nothing
9	nothing
10	nothing
11	nothing
12
Worksheet2

Thanks, Kevin9999. I really appreciate it!

 

[kevin9999]

Thanks, Kevin9999. I really appreciate it!

You're welcome, and thanks for the feedback