Spreadsheet: 719225d1613565299-index-match-find-value-in-given-row-then-return-diff-value-in-same-row-and-diff-column-explanatory_problem
Sheet: Budget v. Actuals

 | Example Income Statement, Actuals + Forecast |  |  |  |  |  | Color coding key
 | cash basis, $ in thousands |  |  |  |  |  | Green cell = lookup from another tab
 |  |  |  |  |  |  | Blue cell = hardcode
 |  |  |  |  |  |  | Red cell = coding for formulas
 |  |  |  |  |  |  | Black cell = formula
 |  | Actuals |  |  |  |  |  |  | Forecast (Goes Actual when [NAME] from [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  | Coding Columns
 |  | 2020-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Account Description | Large
 | Actuals plus Latest Forecast
 | Foundation Donations: $100k+ |  | 0 | 0 | 100 | 750 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Foundation Contributions | Yes
 | Foundation Donations: <$100k | 0 | 0 | 75 | 80.2 | 32.2 | 0 | -0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Foundation Contributions | No
 | Other Donations | 250 | 0 | 0 | 0 | 52.9587 | 0 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | Individual Contributions
 | Total Donations | 250 | 0 | 75 | 180.2 | 835.1587000000001 | 0 | 24.8 | 125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Investment Income | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Management Fees | -15 | 0 | -4.5 | -30.812 | -32.10838 | -9 | -1.5 | -8.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Net Revenue | 235 | 0 | 70.5 | 149.388 | 803.05032 | -9 | 23.3 | 116.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Salaries | 0 | 0 | 0 | 0 | -4.78842 | -7.5 | 0
 | Bonus | 0 | 0 | 0 | 0 | -3 | 0 | 0
 | Employer Taxes | 0 | 0 | 0 | 0 | -0.84699 | -0.6966700000000001 | 0
 | Personnel | 0 | 0 | 0 | 0 | -8.63541 | -8.196670000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | General | 0 | 0 | 0 | -12.67358 | -93.74461 | -20 | -80.13028999999999 | -105.13029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Consultants: Project Management
 | Communication | 0 | 0 | 0 | 0 | -47.5 | 0 | -41.28842 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Consultants: Communication
 | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Consultants: Other
 | Consulting | 0 | 0 | 0 | -12.67358 | -141.24461 | -20 | -121.41871 | -105.13029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Software & Technology Licenses | 0 | 0 | 0 | 0 | -0.348 | 0 | -0.19075 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Website Costs | 0 | 0 | 0 | 0 | -0.29596 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bank Service Charges | 0 | 0 | 0 | 0 | -0.14018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Operating Expenses | 0 | 0 | 0 | 0 | -0.78414 | 0 | -0.19075 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Expenses | 0 | 0 | 0 | -12.67358 | -150.66416 | -28.19667 | -121.60946 | -105.33029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Net Cash Income | 235 | 0 | 70.5 | 136.71442 | 652.38616 | -37.19667 | ` | 10.91971000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Beginning Cash | 0 | 235 | 235 | 305.5 | 442.21442 | 1094.60058 | 1057.40391 | 959.09445 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001
 | Ending Cash | 235 | 235 | 305.5 | 442.21442 | 1094.60058 | 1057.40391 | 959.09445 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001 | 970.0141600000001
 | Implied Runway
 | reconcile
 | Sheet Infrastructure
 | Month
 | Quarter
 | Year
 | Month, Year
 | Quarter, Year