Search results

Sorry for the delay in getting back to you. I can't open dropbox from my phone (or work), but your fix works fine. I never would have thought of it. Thank you!

So I made a few more adjustments to it. I used an if & index/match to pull in the budget data only at the first instance of each item. This is basically how I want it to look. However the budget is really tied to the item not the cost account. Any way to remove the details on the Sum...

Finally got the sample file to upload from my phone: https://www.dropbox.com/s/ovlvqo46nihgzlh/PivotTable%20Lookup.xlsx

Well those columns have sum of budget, sum of actuals, sum of over/under because they are supposed to be in a pivot table. Item Budget Sum of Actuals Sum of Over/Under Budget What sum of Over/Under should be displaying 123 10,000 413.68 29,586 9,586 124 20,000 6.16...

I'm trying to get this: Item Sum of Budget Sum of Actuals Sum of (Over) / Under Budget 123 30,000 413.68 29,586 124 60,000 6.16 59,994 125 30,000 11.66 29,988 126 60,000 15.69 59,984 Grand Total 180,000 447.19 179,553 But I want the budget...

Thank you for the response. I've been searching here and elsewhere for two days now and maybe I'm just not framing my question properly, because I've not found anything resembling my problem. Ideally, I'd like to put that last little table above into a pivot table. However when I do that the...

Hello. I’m trying to display some budget data and utilize some of Excel’s calculated fields, but I can’t get it to work properly. I’m using an Index/Match formula to combine this data: Item Budget 123 10,000 124 20,000 125 15,000 126 30,000 And this data: Item Cost Accounts 123 987 123...