Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions |