Using Lookup functions to translate data required to generate excel

I have scenario as below -

Country List Country Code Field Name
France 1 Country_Field
Germany 3 Country_Field
USA 4 INTAKE_FIELD
EUR 2 INTAKE_FIELD

I have to populate a column in generated excel which must contain values after translation based on selected value of Field Name in mapping with Country List and Country Code.

Output file must generate column like below -

1
4
13
27
89
5
7
8

  Discussion posts and replies are publicly visible