Extract data from table

Hi

I could use some assistance on 2 formulas as on my attached file.

1. in Sheet1 - On cell C2, I need the yellow highlighted cell to extract the figure that is indicated on the table in sheet2 based on the current month that is indicated on sheet1 on cell B2. the answer would be 54269.
2. in sheet 1 - on cell C6, i need the green highlighted cell to extract the figure that is indicated on the table in sheet2 based on the month and year that is selected on sheet1 cell B6. The selection should be based on the months and years that are indicated on the columns that are in sheet2. For example if jan 2018 is selected than the answer would be 16639.01

In C2

=INDEX(Sheet2!$B$4:$G$15,MATCH(TEXT(TODAY(),"mmmm"),Sheet2!$A$4:$A$15,0),MATCH(YEAR(TODAY()),Sheet2!$B$3:$G$3,0))

Similar in C6

=INDEX(Sheet2!$B$4:$G$15,MATCH(TEXT(B6,"mmmm"),Sheet2!$A$4:$A$15,0),MATCH(YEAR(B6),Sheet2!$B$3:$G$3,0))

Thanks all it worked perfect

Hi, can i have one more guide on this thread. If cell B3 just had the year, and i want to retrieve the average of that year from the table in sheet2. How can i amend the below formula

Please Login or Register  to view this content.