LOOKUP Function from column base to Row Base

[Romie]

Hi All,

i want to do lookup from Source Sheet to Working file sheet
i have list of CITY morethan 20 and List of SKU morethan 400 , doing this manually will consume time a lot

i have no idea what formula can help me to prompt my task, at this point of time, i do vlookup by manually selection on the source array as per City.

will be glad if someone can help me.

attached file with expected result in working file sheet with yellow highlighted

Thank you.