title: Match up correlating columns in excel
body: <p>I have one column which stays the same. I have data in column B and C which correlate with each other. I want the text and number in column B and C to match up with the text in column A. </p>
  
  <p>Question: How can I successfully sort column B and its correlating column C to match column A?</p>
  
  <p>For Example 
  before:</p>
  
  <p>A    C    20<br>
  B    E    50<br>
  C<br>
  D    A    10<br>
  E    </p>
  
  <p>after:</p>
  
  <p>A    A    10<br>
  B<br>
  C    C    20<br>
  D<br>
  E    E    50</p>
  
  <p>I have tried =IF(ISERROR(VLOOKUP(A2,$D$2:$D$23,1,0)),"",VLOOKUP(A2,$D$2:$D$23,1,0)) but this only matches column B with column A (based on the example above).</p>
  
  <p>Thanks in advance!</p>