Hello,

I am looking for a way to add data in a custom column in Power Query similar to the VLOOKUP function in Excel.

In short, my data source contains data of users and the name of the country they live in. What I want is to look up the country name against another table / query and from that get the region name.

Example: A user lives in Sweden, in the custom column it should then be listed Scandinavia. Another user lives in Tokyo, the custom column should then list Asia. And so forth.

Is this possible?

Br,

Anders