Hi,
in C15 to be copied across
=INDEX($C$5:$N$8,ROWS($1:1),MATCH($B$12,$C$4,$N$4,0)+COLUMNS($A:A)-1)
Hope it could be of some help
Not working. But I did this and worked. LOL. on C15:
=INDEX(C$5:N$8,MATCH($B15,$B$5:$B$8,0),MATCH($B$12,$C$4:$N$4,0))
I am having new issue now. How do you add the value of same name from another sheets (Like collecting SUM values from other sheets)? I can do +Sumproduct on each sheet. But I need to do the SUM on only 1 sheet. I hope you understand me. Attaching example sheet. See sheet1, 2, 3 from Help 2.xlsx
THANKS~!!!