Find Value with duplicate values in columns

Hi,

Need some help with this table:
I try Index plus MATCH but the formula only find the 1st value duplicated. With Aggregate works? how?


London London London Paris Paris Berlin
Hot Cold Warm Hot Cold Hot
10 14 23 16 10 31


I want find the value to London + Cold

Many thanks!
Works in a table with more than 100 columns and 3 rows with a lot of duplicated values.

Tks!