I tried to solve and mix the index and match function before shown in video. And the Resultđ
=INDEX($B$4:$F$12,MATCH($I4,$B$4:$B$12,0),MATCH(J$3,$B$3:$F$3,0))
For Country of milan and then draged it in whole. It worked. But after watch the video, I think I should revisit and simplify like the video oneđ„
0 answers ( 0 marked as helpful)