![]() ACCSUM is the named range for the data range A1:I20 on the transactions list worksheet, it is also the data table where we lookup data.Ĭ. We used the formula =VLOOKUP(A6,ACCSUM,MATCH($A$1,Headings,0),0) to lookup values from the transactions list worksheet.ī. ![]() The values displayed will be extracted from the transactions list worksheet.ģ. To view the Income & Expenditure Statement for a specific month, click the drop down arrow in cell A1.Ģ. You will find the Income & Expenditure Statement on the monthly income statement worksheet.ġ. The accounts transactions data is on the transactions list worksheet. ![]() Note: Download the template to practice this exercise You are welcome to share the template with anyone that will benefit from it. We have also provided step by step instructions on how to use it. ![]() This week you are getting something different! We’ve created a template for an Income and Expenditure Statement that you can customise with your own information to save you from agonising over how to use Microsoft® Excel® formulae to look up data.
0 Comments
Leave a Reply. |