Question
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 |