Matching list of numbers from column of min and max numbers ranges

[TJ2]

I have a list of numbers (Master#) that I need to determine if any of them are within this list of min-max numbers and somehow identify a match.

This is just a small sample as the Master# list contains >1000 numbers and the Min Max rows can be >200 different ranges

Master#		Min	Max
71100100		71100100	71100108
71100101		71100110	71100110
71100102		71100151	71100158
71100103		71100200	71100212
71100104		71100214	71100216
71100105		71100218	71100220
71100106		71100221	71100221
71100107		71100300	71100313
71100108		71100314	71100315
71100110		71100350	71100351
71100151		71100419	71100420
71100152		71100422	71100423
71100153		71100433	71100433
71100154		71100435	71100436

I think this depiction below can better explain the challenge.

Any help on how to accomplish this would be appreciated.

Thanks

[ydmuley]

Hello @TJ2 

Please try this formula.

IF [Master#] >= [Min] AND [Master#] <= [Max] THEN "True" ELSE "False" ENDIF

[Greg_Murray]

@TJ2 

If I understood you question correctly, I think this might be what you are looking for. 

Greg

[TJ2]

Thanks for the response. In looking at the solution I edited the question in order to clarify the problem.

[Greg_Murray · Accepted solution]

@TJ2 

I think the solution I posted above meets your adjusted requirements.

-Greg

[TJ2]

Thanks. I can work with this.