Result of multiple vlookups in one cell

[dhineshreddy]

Hi all,

I m Looking to write a formula for below requirement. But not easy.

Country Number. Result
DE. 1. DE. GB
GB. 1. DE. GB
DE 1. DE. GB

Anyone has sn idea what can b fone plase?

BR,

 

[dhineshreddy]

Hi all,

I m Looking to write a formula for below requirement. But not easy.

Country Emp Number Result
DE 1 DE GB
GB 1 DE GB
DE 1 DE GB

Anyone has sn idea what can b fone plase?

BR,