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
Bookmarks