Finding a range of numbers in a column of numbers

[Charles665]

Hey everyone.

I have a range of numbers (ex. 111111111-555555555) and i have a column of 2000 9 digit numbers in different spreadsheet. Is there away to create a formula that will tell me if any of the numbers in my range are in the 2000 numbers in the column? I hope that made sense. 

Thanks in advance

[#2]

@Charles665 

You may use MATCH function to check whether a number exists in another range.

Please refer to the attached which demonstrate how to use MATCH function. There are two formulas one in column B and another in column C, choose one which suits to your requirement.

[#3]

Thank you so much. That was exactly what I was looking for.

[#4]

@Charles665 

You're welcome! Glad it worked as desired.

Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.