Hi all again,
I have yet another question regarding index and match formulas. I would like to draw a set of data based on the year and month of the date data.
I am not really good at explaining this, so i have attached a sample file of what i will like to do. I will like to use index and match to draw data from the volume column in sheet 1, and it is based on the date column in sheet1 as well. Then i would like to have this data displayed on the monthly table in sheet 2.
Is there anyone that can help me with this?