CODEWITHSUNDEEP
matchinglibreofficelibreoffice-calc
prkos
prkos

Reputation: 685

Match Column A to Column B, then output Column C from the same row as Column B

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.

Upvotes: 0

Views: 4527

Answers (1)

Holzchopf
Holzchopf

Reputation: 397

VLOOKUP is the function you're looking for.

Upvotes: 1

Related Questions