Forum Discussion
Finding a range of numbers in a column of numbers
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
3 Replies
- Thank you so much. That was exactly what I was looking for.
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.
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.
