title: Match Column A to Column B, then output Column C from the same row as Column B
body: <p>Column A is a smaller set of values from Column B. Column C is related to Column B. </p>
  
  <p>You can think of this data as Countries in Columns A and B. Column C contains capital cities of countries in Column B. </p>
  
  <p>I need to output correct capital cities for Column A countries by matching with Column B. </p>
  
  <p>This is simiar to this question: <a href="https://stackoverflow.com/questions/26373325/if-two-cells-match-return-value-from-third">If two cells match, return value from third</a></p>
  
  <p>but I need it applied to Libre Office Calc. </p>