Function to indicate which values in a column fall between a long list of separate ranges

[dtan777]

I need a function or macro that can help me go through a list of numbers (e.g Column A) and indicate to me which of these numbers fall between multiple number ranges that are listed (e.g Column B gives the lower limit, Column C gives upper limit within the same row). Help??

[Fotis1991]

Assuming that your data starts in A1, then in D1 and copy down, try this.

=IF(AND(A1<=C1,A1>=B1),"OK","Out of range")

[dtan777]

Thanks for replying! I tried this and it only checks the range within the same row, not through all the ranges listed. Is there a function that can check all of them?

[Fotis1991]

=IF(AND(A1<=$C$1,A1>=$B$1),"OK","Out of range")>>>????

If no, pls upload a sample workbook.

[dtan777]

No, it did not work I attached a sample workbook, where I am looking to find values within Column A "Values" that fall between any of the ranges listed in Column B and C.

Sample.xlsx