I have a list of Mins, and a list of Max's. If someone was to enter
in
a number in D3, I would like for it to lookup the entire list of Mins
and Maxs to see if the number entered falls within range of a Min-Max
row.


Example, since 1801 is between 1800 and 2200, it returns the
equivalent word or number in row C.


If I were to put 550 in D3, it would return APPLES.
If I were to put 1499 in D3, it would return CHERRIES.


A B C D E
MIN MAX
500 1000 APPLES
1200 1500 CHERRIES 1801 PLUMS
1800 2200 PLUMS


Note: I have a long list of mins and maxs.


Thanx