ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Return a value (https://www.excelbanter.com/excel-worksheet-functions/117409-return-value.html)

[email protected]

Return a value
 
I've got a database setup in excel similar to this:

Type Class Line 1/1/2006 2/1/2006
Budget Residential Revenue 77 100
Budget Residential Unbilled 25 32

Actual Residential Revenue 80 110
Actual Residential Unbilled 30 35

Budget Commercial Revenue 65 85
Budget Commercial Unbilled 18 40

Actual Commercial Revenue 50 75
Actual Commercial Unbilled 20 28

I need to produce a report that will compare actual vs. budget for each
class for a given month. I would also like to be able to have a YTD
column on the report. I think my ticket is gonna be using index and
match functions but can't seem to get it to work. Any advice would be
awesome. Thanks.



All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com