Put a condition in a lookup

Options

Input:

ABCDE
FranceGermanySpainPortugalSweden

 

Calculate : 

 BCDE
Origin countryFrance (A)Germany (B)Spain (C)Portugal (D)
Actual CountryGermany (B)Spain (C)Portugal (D)Sweden

 

Hello, 

 

I would like to know if you can help me with the formula for "Origin Country".

It is supposed to send me the information from the previous step to the current step as in the example above.
For the actual country line it's simple but for the first one I don't know how to do it.

Thanks in advance

Best Answer