Mapping data in Google Sheets

[NM]

Hey,
I fetch data from Facebook Ads Campaign Management and add it to a Google sheet as country codes and the amount spent for a certain period. Now, I want to map each row (country code) with an existing Google sheet containing the full country name.

What’s the best approach for this?

[Fario_Consulting]

Hi,
You could use a lookup table in your Google Sheets where you cross-reference the country codes from your fetched data with their full names