title: How can I lookup a value and return the header when an associated cell is less than x?
body: <p>I want to lookup a value in another sheet, and when that value has a cell in its row with a value less than or equal to 25 it returns the value of the header of that cell.</p>
  
  <p>Using the picture example, when I lookup value A I want it to return Z as that is where 5 &lt; 25.</p>
  
  <p><a href="https://i.stack.imgur.com/ta9YY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ta9YY.png" alt="enter image description here"></a></p>