Formula for a number in a range appearing in another range

[matratus34]

Hi,
I'm hoping this will be a pretty simple one for all you experts out there.

I have a range of 5 numbers and I just need a formula to give me a yes/no or true/false for if any of the numbers appear in a different range of 5 numbers.

For example:

Range 1 is 1,2,3,4,5
Range 2 is 7,8,9,10,1

This would be true as 1 appears in both lists.

As always thanks in advance - it's always greatly appreciated

 

[Peter_SSs]

Like this?

Excel Workbook
	A	B	C
1	1		7
2	2		8
3	3		9
4	4		10
5	5		1
6
7		TRUE
Sheet5

 

[matratus34]

Brilliant - thank you

 

[Peter_SSs]

Brilliant - thank you

You're welcome.