title: How do I sort two columns in excel by values matching column A?
body: <p>Hi I have two columns in excel with numbers.
  Column A has more numbers than Column B.
  I want to sort Column B by values that match in Column A
  If the value in column A cannot be found in column B i want column B to display <code>"MISSING"</code>
  I have already sorted both columns in ascending order.</p>
  
  <p>eg. of the output I want:  </p>
  
  <pre><code>A       B  
  2001    2001  
  2002    2002  
  2003    MISSING  
  2004    2004  
  2005    MISSING  
  2006    MISSING  
  2007    2007  
  </code></pre>
  
  <p>Please suggest what formula I should use. Thanks</p>