title: How to identify if a value is between to values in a array and repeat for the entire array - Excel
body: <p>I have a long list of numbers (sizes actually) in column F. In column N and O, I have a lower and upper bound respectively. In column M, I have a label for each set of bounds (A, B, C, D, E, etc.)</p>
  <p>What I need to do do is check each value in F. If the value is between the first items in N and O, A will be put in column E next to the value being checked. If not I want to go down the list of N and O until I identify which bounds the value is between and select the corresponding letter.</p>
  <p>I'll drag this code down to do the same check for every value in column F.</p>
  <p>For example I have typed =IF(AND(F7&lt;$O$13,F7&gt;$N$13),$M$13, &quot;&quot;) into E9 and outputs &quot;F&quot;. However it only checks the bounds corresponding to letter F. If this IF statement were to result in False, I would need the formula to then check O/N/M14, then O/N/M15, etc.</p>
  <p>Happy to clarify if the question is confusing and appreciate any help!</p>
  <p><a href="https://i.stack.imgur.com/Ght20.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ght20.png" alt="enter image description here" /></a></p>