Lookup and Match Formula from tabulated format

Dear Experts,

Please find here attached workbook, I am looking for the formula for Income and Expenses forecast and Actual based on the provided two tabs data. The raw data is in table format and based on the selection of the Bank and Period in the Report tab, i do expect to appear the numbers for the particular Bank in Row 5 (In Forecast and Actual Tab) and Period in Row 3 (In Forecast and Actual Tab).

I am also looking for the formula for the related Quarter and Full Year in the Report tab with the same data.

Request to you please do help me out on my thread. Thank you for your precious phase and valuable support.

Regards,

Neilesh

Originally Posted by Glenn Kennedy

Hi. I have looked (so far) only at the Forecast part of this.

To be honest, your Pivot Tables make life far more complicated than needed. Is it OK to ignore them and work from the Raw data?? I have compiled only the raw data for Forecast. Check it over. Is it what you wanted?

Dear Sir,

Thanks a ton for your precious help. I am really highly obliged to you. Can you please do the same for Actuals and put the formula for Actuals for Month, Quarter and Year Columns.

Once again thanks a ton for your valuable support Sir.

Regards,

Neilesh

Originally Posted by Glenn Kennedy

Did you not try to do it yourself? that's how you learn...

Dear Sir,

Thank you once again and I really do appreciate your valuable contribution and precious phase Sir. I tried Sir but unfortunately i could not able to resolve. I am not that level of Expert Sir as you are.

Once again thank you so much Sir for your precious help.

Regards,

Neilesh