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