title: Vlookup returns wrong results near bottom of sheet
body: <p>I have a table like this:</p>
  
  <p><a href="https://i.stack.imgur.com/EDpUl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EDpUl.jpg" alt="enter image description here"></a></p>
  
  <p>I need to look up the text in <strong>column A</strong>, and find an appropriate result for it, and place that in <strong>column B</strong>.</p>
  
  <p>So I created a new reference list, and it looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/N974y.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N974y.jpg" alt="enter image description here"></a></p>
  
  <p>This is the formula I used in <strong>Columns B</strong></p>
  
  <pre><code>=VLOOKUP(B1, MyList, 2)
  </code></pre>
  
  <p>It appears to work OK at first, however once I got past <em>result5</em>, my code was only able to show the result "result5". Something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/lnYbC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lnYbC.jpg" alt="enter image description here"></a></p>
  
  <p>I don't know why this is. My true list is larger and has over 13,000 rows.</p>
  
  <p>Thanks</p>