View Single Post
  #1   Report Post  
Dominique Feteau
 
Posts: n/a
Default 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?