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 ...
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.