In sheet 1, I have a list of ranges as follows, with a true false value associated to the range in excel.
1000 |2000 | False
2001 | 9001 | True
9002 | 13121 | False
....
In separate sheet 2, I have a list of numbers below as follows
9003
9900
1500
2200
Basically I want to check to see if the numbers in sheet 2 is in one of the ranges in sheet 2, and indicate the corresponding False / True Value.
i.e. it would result in this:
9003 | False
9900 | False
1500 | False
2200 | True
I was wondering the best way to do this?
Bookmarks