Excel Formula Help!

%3CLINGO-SUB%20id%3D%22lingo-sub-2294255%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2294255%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20need%20help%20trying%20to%20make%20a%20worksheet%20do%20something.%20I%20have%20a%20worksheet%20that%20is%20calculating%20a%20budget.%20It%20is%20broken%20out%20by%20'Description'%20(column%20A)%20and%20into%20'Projected%20Cost'%20(column%20B)%20and%20'Actual%20Cost'%20(column%20C).%20In%20cells%20O%20and%20Q%20I%20have%20the%20actual%20'Actual%20Cost'%20(column%20O)%20and%20the%20'Description'%20(column%20Q).%3C%2FP%3E%3CP%3EI%20want%20to%20have%20the%20'Actual%20Cost'%20(column%20C)%20in%20my%20budget%20break%20out%20to%20automatically%20update%20by%20matching%20the%20'Description'%20(column%20Q)%20to%20the%20'Description'%20(column%20A)%20in%20the%20budget%20breakout%20and%20then%20copying%20the%20'Actual%20Cost'%20(column%20O)%20to%20the%20'Actual%20Cost'%20(column%20C)%20in%20the%20budget%20break%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20figure%20out%20how%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2294255%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2295964%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2295964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1037232%22%20target%3D%22_blank%22%3E%40sheila1089%3C%2FA%3E%26nbsp%3BI%20created%20a%20small%20example%20(attached)%20based%20on%20your%20description%20and%26nbsp%3Bused%20SUMIF%20to%20sum%20(in%20col%20C)%20the%20actual%20cost%20(col%20O)%20with%20the%20budget%20(col%20B)%20based%20on%20Descriptions%20(col%20Q).%20See%20if%20this%20works%20for%20you.%20If%20not%2C%20come%20back%20here%20and%20perhaps%20upload%20an%20example%20of%20your%20real%20workbook%20(remove%20any%20confidential%20information%2C%20though).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello! I need help trying to make a worksheet do something. I have a worksheet that is calculating a budget. It is broken out by 'Description' (column A) and into 'Projected Cost' (column B) and 'Actual Cost' (column C). In cells O and Q I have the actual 'Actual Cost' (column O) and the 'Description' (column Q).

I want to have the 'Actual Cost' (column C) in my budget break out to automatically update by matching the 'Description' (column Q) to the 'Description' (column A) in the budget breakout and then copying the 'Actual Cost' (column O) to the 'Actual Cost' (column C) in the budget break out.

 

Can someone help me figure out how to do this?

2 Replies

@sheila1089 I created a small example (attached) based on your description and used SUMIF to sum (in col C) the actual cost (col O) with the budget (col B) based on Descriptions (col Q). See if this works for you. If not, come back here and perhaps upload an example of your real workbook (remove any confidential information, though).

 

@Riny_van_EekelenHello! thank you so much, this worked!!!! I do not know how I did not think of this but I appreciate your help!