Check if values are within a list of ranges

Hi All,

Please can anyone assist.

I have a list of numbers in range A1:A10, a table consisting of two columns (D1:E5), the table contains varying ranges, eg D1 = 10, E1 = 19, D2 = 20, E2 = 29, etc, not corresponding ranges.

I would like a formula that, when entered into B1:B10, will check to see if the value is within one of the ranges, ie, if A1 = 10, then is would be a TRUE, as the value 10 is within range 1 (D1=10 to E1=19).

Image of Sample spreadsheet attached.

Thank you all.

Sample.PNG

Try this in B2

Formula:

Please Login or Register  to view this content.