Additional selection

Hi there,

Can anyone enlighten of how to go about to add in an additional formula to the worksheet attached?

Currently I am using index and match function to do the selection by month in sheet 1 cell 8 =INDEX(Sheet2!$C$4:$H$11,MATCH(A8,Sheet2!$A$4:$A$11,FALSE),MATCH($B$6,Sheet2!$C$3:$H$3,FALSE))

But, I am trying to add in a formula so that the worksheet match the year as well as to sheet 2 starting from C2:H2 because the data was started from 2006 to 2007 and for Jan to March each year.

Can anyone help?

Hi

Have a look at the attached.

I've only made a change to B8 so see if that gets you going and you can expand as required.


rylo

Hi Rylo,

Thats exactly what I want. I am so thankful for your help.

Regards,
Justinkv