I want to sum or lookup data based on a column and row criteria. Basically, I want to find a number based on a month and row text description. I've attached the worksheet. 'Sheet2' has the data that I need to be populated into 'Apr' C2.
I will be adding a column between E&F which will represent May 2015 and adding commission expenses in rows 7-10 that I hope to populate into tab 'Apr' C3.
Sorry for the late response. The first time you helped me you gave me a formula that matches month in tab 1 to tab 2, but now i'd like to match the rows with the column that states YTD.