I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a more...
current projects are received at the start of each year, followed immediately by
any required cash outflows. Set up and solve a linear programming spreadsheet model for this problem.
b. Now suppose that there are no other potential investors in the Aberdeen Resort Hotel project. Thus, ADC
must participate more...