Calculating amounts from categories automatically

Occasional Visitor

Hello Excel gurus!


I am pretty much a newbie to doing anything beyond basic in Excel. I am working on a budget which I will try my best to explain. I am sure the answer exists somewhere out there, but I am not able to find the right question.


In Sheet 1 I have a budget breakdown, which includes a column for the budget category (eg - lighting, accomodation etc), a column for amount spent, a column for total remaining, a column for reforecast and a column for approved budget.


In Sheet 2 I have the beginnings of a list of expenses. Theres a column for date, category, description, status (spent, committed, forecast), cost and notes. I have added a dropdown to the category column for each of the categories listed in Sheet 1. I would like to auto populate Sheet 1 with these expenses as they are logged in Sheet 2. So every time someone picks Lighting from the category dropdown in Sheet 2, its adds it to the spent amount against lighting in Sheet 1. 


Does this make sense?


Help muchly appreciated!!






1 Reply
Perhaps, a simple VLOOKUP will do the job.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies