Select cell that contains data from 2 cells and use it for calculation on another worksheet

[chocolatedogs]

I tend to make things much harder than required, so I thought I should garner expertise first.

I have a workbook with 2 worksheets. One is the P&L worksheet, and the other is the CASH FLOW worksheet.

The P&L worksheet has 2 tables, one for the BUDGET numbers, and one for the ACTUAL numbers. The tables do not change size.

I need to select the cell in the appropriate table that contains data and use it - if the ACTUAL table has data, then use it for the CASH FLOW worksheet calculation. If it does not contain data, use the BUDGET value for the CASH FLOW worksheet calculation.

This is a one-time set up so it needs to be as simple as possible – if it needed to be done frequently I would go for a more permanent solution. Any help would be greatly appreciated!

Sample setup:

P&L Worksheet

BUDGET
Month 1 Month 2 Month 3 Month 4
Item 1 150 275 495 125
Item 2 125 325 555 375

ACTUAL
Month 1 Month 2 Month 3 Month 4
Item 1 125 450 No Data No Data
Item 2 345 775 No Data No Data


CASH FLOW worksheet

Month 1 Month 2 Month 3 Month 4
Cash flow 1 Actual Actual Budget Budget
Cash flow 2 Actual Actual Budget Budget

 

[Muhammad_Usman]

Upload Excel sheets with expected result

 

[Aladin Akyurek]

Upload Excel sheets with expected result

Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit (Note that an image or a link to a storage site like dropbox or onedrive etc. does not provide a permanent record.). Mind you a forum without a permanent record is not of much value.

 

[chocolatedogs]

I mistakenly posted this twice - the other thread has the attachment. My apologies for the confusion.