Thread: Translator function

Hello, and thanks for read.

I want to translate country codes ISO to FIPS.

I have a column with ISO codes an other column with FIPS codes.
Equivalents in the same row.

I have other column with cities' names, next to other column with the ISO code of the country of city.

I want to translate each ISO code to FIPS code in the cities column.

For more comprehension, see this part of my spreadsheet
___________________________________________________________________________
ISO_COLUMN........FIPS_COLUMN.........................ISO_COLUMN_CITY.........CITY_COLUMN
ES................................SP................................................ES.............. ..................BARCELONA
AW................................AA.............................................ES................. ...............ZARZA
MA................................MO.............................................ES................. ...............ZUBIA
___________________________________________________________________________

There are many more cities with ES and many more different cities with the same ISO code, for this reason I don't want to do that manually.

I want to translate data in ISO_COLUMN_CITY using a function.

If the columns that you showed are A, B, C, D, then assume E will have the FIPS code for that city.

In E2 use:

=VLOOKUP(C2,A:B,2,FALSE)

and copy down