Purchase the Controller Bundle at 30% off with code 30offcourse: https://thefincontroller.com/p/controller-bundle-3-courses-learn-accounting-kpi-design-kpi-dashboard-download-and-course Download your Index Match practice file: https://thefincontroller.com/p/index-match-example 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: 📸 https://www.instagram.com/the_financial_controller/ 📱https://www.tiktok.com/@thefinancialcontroller 🙋🏼♂️https://www.facebook.com/groups/780732429036886/?source_id=101273467885666 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
How to use Index Match in Accounting and Financial Analysis (Step-by-Step)
Basic Accounting Terms | Class 11 | Accounts | Part 2
What's New in Odoo Accounting?
Excel for Finance and Accounting
ACCOUNTANCY BASICS: Credits and also debits Explained
FTX Infinite Money Diagram | Accounting and Collapse Explained
Angela, Kevin and Oscar's $3,000 Accounting Mystery - The Office
Accounting for Beginners | Part 1 | The Accounting Equation
Why Cash Accounting is MISLEADING!! Accrual vs. Cash Accounting Explained
The ACCOUNTING EQUATION For BEGINNERS
THE SECRET LEVELS - Accounting + (VIRTUAL REALITY).
Hire the best with a Financial Accounting (IFRS) skills test
Asking Accountants Their Favorite Tax Write Offs
clear and consise, thanks!
Nice like xlookup
Thanks for the video, I was using indexmatch until I found xlookup, found it personally easier
I love it, Thanks
I’m glad you like it
Hi Bill , Can we approach this with xLookUp too ?
Yes for sure
Agent X{lookup} “No you use that old and busted formula, I drive that new hotness.”
I must check it out!
Hi Bill,
Formula
=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.
@The Financial Controller XLOOKUP is super great.
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
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).
Nice to refereshing excel for accountant useful one thank you brother
Always welcome
clear and useful! thanks! regards from argentina
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!
Great to hear!
Thanks for the video <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?
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
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.
Great video, make it dynamic, really helpful, thanks
Thank you and it was very useful..
Glad it was helpful!