The index value in B1 is the index for the data on sheet Account01.
You need to create an index value for the data on sheet Account02.
In ChartData!G1 use this formula
=MATCH(INDEX(Account01!A2:A44,B1,1),Account02!A2:A41,0)
And change the references to $B$1 in row 4 to $G$1
note you will get a few #N/A records as there is not a 100% match between the 2 lists.
Bookmarks