title: Unable to understand complex VLookup Function
body: <p>I'm having trouble understanding the result of this function <code>VLOOKUP(A39,'pvtBM ATP'!$A$4:$E$9,5, FALSE)</code>.</p>
  <p>e.g. in the <code>A39</code> cell, the value is <code>'&lt; 8 days'</code>
  As you can see in this screenshot:</p>
  <p><img src="https://i.stack.imgur.com/LKr73.png" alt="enter image description here" /></p>
  <p>Range From <code>A4:E9</code> has the data in the image below:</p>
  <p><img src="https://i.stack.imgur.com/xvy6y.png" alt="enter image description here" /></p>
  <p>So the highlighted value in the above screenshot has the result of the formula which I'm unable to understand.</p>
  <p>How is this function providing the highlighted result?</p>