How to use Index Match in Accounting and Financial Analysis (Step-by-Step)

Purchase the Controller Bundle at 30% off with code 30offcourse: Download your Index Match practice file: How to perform Index Match in Excel: The basics. Watch this video lecture to find out how you can use Index & Match for both basic and complex lookup problems. This video shows you how Index Match works with simple and to the point explanation. The video first shows you how Index formula works by itself and then how Match is created, and then combines the two Excel formulas together for a robust lookup each time. Why Index Match is more superior than Vlookup & why should you use Index Match instead of Vlookup? 1. VLOOKUP searches only to the right, INDEX and MATCH can look in both directions – left and right. 2. INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix. 3. INDEX & MATCH produces less errors. Overall, INDEX and MATCH are more flexible than VLOOKUP. Hang Out with me on social media: 📸 📱 🙋🏼‍♂️ DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week! All views expressed on my channel are mine alone. Not intended as financial or professional advice

25 thoughts on “How to use Index Match in Accounting and Financial Analysis (Step-by-Step)

    1. Hi Bill,
      =XLOOKUP($J$3,Table1[Month],XLOOKUP($H$5,Table1[#Headers],Table1)); I turned the data set into a table. Looks as unwieldy as the index, match one. Hvnt tested speed of this approach vs index, match.

  1. Hello brother I want to ask you please and i hope to get answer. Which one more flexible Accounting or finance and can accounting do finance job and finance can do accounting job? thank you so much sir

    1. Accounting is a subset of finance. Finance is the broader classification like marketing, sales, operations, human resources etc. Accounting focuses on the day-to-day flow of money in and out of an organization; finance manages money and investments. Accounting is the recording and reporting of a company’s financial records. Those who work in accounting use a standard set of rules and principles, known as the GAAP, to track and report the financial transactions of a business and often manage the general ledger, cash flow, and tax obligations. Finance professionals work in careers such as investment banking, wealth management, and financial planning and analysis (FP&A).

  2. Im not the most advanced in excel and didnt even know about this feature. This is going to be something really helpful in my tool bag of tricks. Thanks for sharing! Love these kinds of videos!

  3. Hey Bill,
    I am a controller , but I didn’t start my career in a big 4 , or an accounting firm, and with that there are skills that are hard to get if a career was developed outside of those types companies. Many roles, do require you to understand Technical Accounting, which in simple terms is the application of what FASB produces to specific items in your Financial statements. I don’t know if this is something you work with , but there is nothing to be found on how to develop technical accounting skills on the internet, or that even explains what this role in companies does.

    Also when it comes to internal controls, and the SEC there is nothing out there , outside maybe of being COSO certified that helps someone who is developing an accounting department from the ground up know what needs to be set up if you are going to go through an IPO or want to bring your company to a state of where External auditors will sign off on what you have, and have no material deficiencies , etc.

    So, if it’s too hard to teach all of this, how does a controller go about meeting these demands even if he hasn’t had specific training on them?

    1. Hi Paulo – many times I engage outside firms to help me write memos on technical accounting matters. I’ve also had situations were we hired a firm for internal control development, granted it’s expensive and you need budget for it, but I am just giving you the option. A cheap way is attend controller/accounting groups, pick people brains and draft your own memo/controls and the have outside firm review (cheaper than actually coming up with). Hope this helps. great questions

  4. hi, that was great video, thank you! you should do more excel videos related to financial analysis I guess not I am the only financial anyalst whos weakness is excel.

Leave a Reply

Your email address will not be published.