Get values from a line item looking for a market zone = X, separate column Market zone = Y

I have separate columns of forecast and typology  each divided into different market zones.   


Forecast EMEA, Forecast APAC ..  


Typology EMEA , Typology APAC


The data is with one line item with all market zones dimensions


I need to split it into separate values, I am having trouble with the formula. 


I am trying to get Market zone = a specific list element  but not working out..


Any insight on how to do this? 




    Can you provide more details about the dimensions of the modules and the expected result you are looking for in which format?