0

Column A is a smaller set of values from Column B. Column C is related to Column B.

You can think of this data as Countries in Columns A and B. Column C contains capital cities of countries in Column B.

I need to output correct capital cities for Column A countries by matching with Column B.

This is simiar to this question: If two cells match, return value from third

but I need it applied to Libre Office Calc.

prkos
  • 449
  • 4
  • 12

1 Answers1

1

VLOOKUP is the function you're looking for.

Holzchopf
  • 263
  • 1
  • 10
  • Thank you! It works. It took some time to get it to work because I was entering `FALSE` for the last parameter because my columns aren't sorted and to get a reliable error message if there are no matches, but it turns out I _had_ to enter `0` instead of `FALSE`. In the end it was `=VLOOKUP(A2;B$2:C$249;2;0)`. – prkos Sep 13 '18 at 21:38