Lookup Value between 2 ranges
I have a table that looks like this.
From To Port#
1 263 1
264 993 1
1100 1368 2
2670 3464 3
I have another table that has random numbers. I need a formula that will
look at the start and end numbers and give me the Port #. For example if
1212 was in e2, i'd want e3 to say "3".
Can anyone help me out?
|