title: Value between or search in range and return value in excel
body: <p><img src="https://i.stack.imgur.com/boX6b.png" alt="enter image description here"></p>
  
  <p>Hi All,</p>
  
  <p>I have a table for employee scores levels (Table D1 to F6), there is points for each level, for example score (4.60) will be in the 3rd level which has (3) points.</p>
  
  <p>I want to write a formula in the column (B) to check in the table an return the point value from the column F, You can see the examples in D2 &amp; D3.</p>
  
  <p>Regards
  Adel</p>