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?