Hi guys,
i need some help here integrating 'indirect' function with 'index/match' function.
i have an excel spreadsheet which contains several tabs, which named as (CPU 95thP, 201501, 201502, 201503, 201504 etc)
on my main tab, as below, which im trying to type the "indirect, index/match" formula to pull the data from 201501, 201502, 201503 etc
(pls note that the date in row 1 is in custom date format)
[ATTACH][/ATTACH]
while for the date sheet, the data look like this, (as below), im trying to get the data from column C
[ATTACH][/ATTACH]
this is the formula i have typed out so far, but it's is badly not working..lol
=INDEX(indirect(TEXT(J$1,"yyyymm")&"!$C3:C8326"),MATCH('CPU 95thP'!A2,indirect(TEXT(J$1,"yyyymm")&"!$C3:C8326"),0))
can someone pls help?
spreadsheet attached
sdfsdfsdf.xlsx
Bookmarks