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

[@nsavernon]

I do this for all of my pre-paid schedules. I tie it into the month end date that I’ll have on the tab… my numbers just roll over without me having to do any calculations it’s brilliant

[@rickybrotega]

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!

[@TheFinancialController]

Great to hear!

[@zan1971]

That's a super useful tool. Now I know how to create dynamic lookups. Xlookup I don't know if it works with match functionality so this seems better tbh.

[@Wilhelm96]

This is just exectly what I was looking for to learn next. Second video of yours and the explanation is great! Easy understandable for an amateur like me. Thx for sharing your knowledge! (:

[@TheFinancialController]

Glad it was helpful!

[@donepudiramu]

I like your explanation on index and match formula with your examples. Great Job ❤

[@hanhtikesoe3979]

Happy New Year Bill. You have no idea how much I'm thankful to you. I'm an expat working as a financial analyst in Bangkok. If you ever had a chance to travel to Bangkok, Thailand, please let me know. I'd like to treat you something delicious.

[@TheFinancialController]

Happy new year! I will take you up on it, one day

[@accounting_for_everyone]

Hello my brother, I have been using the combination of index and match for years and it is a wonderful combination and the vlookup formula has many flaws, but in version 2021, the xlookup formula has been added and the vlookup flaws have been fixed.

[@PraveenCJRegina]

Thank you, Bill, for your great informative videos. Thanks to your videos, I have become a Financial Controller of a more prominent organization, especially the following videos - Five Financial Analyst Behavioral Interview Questions & Answers, Five Advanced Financial Analyst Interview Questions, and How To Analyze Financial Statements For A Corporation. Four Types of Financial Analyses & How To Read & Analyze The Balance Sheet Like a CFO. These videos helped me a lot to ace my interviews even if I have more than 17 years of experience in the Finance sector. Now I am planning to take your Controller Academy course. I am confused about whether to take the Controller bundle of 3 courses or just the Controller academy course. Any thoughts?

[@TheFinancialController]

Go for the bundle

[@TheFootballRef]

clear and consise, thanks!

[@lijuansun3778]

Great video, make it dynamic, really helpful, thanks

[@minhluong400]

Other alternative formulas would be sumifs or sum product that will work too in your scenario given you only have one unique month on your look up array

[@lalelale9172]

Thank you so much index/match is the best 💯

[@axelengelmann9044]

clear and useful! thanks! regards from argentina

[@moaazelmansi8932]

Could you explain how to do Trial balance mapping in separated lecture?

[@TheJirator]

Hello Bill, very helpful, thanks a lot!

[@TheFinancialController]

Glad it was helpful!

[@moose5445]

Thanks for the video, that's a handy formula! Out of curiosity, what metrics do you have on your dashboard at the very end?

[@AamirMusthafa]

Well explained.

[@eliasabdissa9406]

Nice to refereshing excel for accountant useful one thank you brother

[@TheFinancialController]

Always welcome

[@saoud2024]

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

[@PraveenCJRegina]

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).

[@gaborsiegl]

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.

[@vijayrajashree4694]

Thank you and it was very useful..

[@TheFinancialController]

Glad it was helpful!

[@PauloSantos-kw7xc]

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?

[@TheFinancialController]

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

[@gsm6120]

Love it!

[@zain4494]

please make a video for bookkeeping/accouting cycle practical at work demonstration

[@kyungeunkim8217]

Thanks for the video

[@TomikoIto]

Thanks for the video, I was using indexmatch until I found xlookup, found it personally easier

[@Totalsells]

I love it, Thanks

[@TheFinancialController]

I'm glad you like it

[@christopherbaby3842]

Agent X{lookup} "No you use that old and busted formula, I drive that new hotness."

[@TheFinancialController]

I must check it out!

[@jenniferlim2250]

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.

[@katestan7002]

@@TheFinancialController XLOOKUP is super great.

[@issamelsayd]

thanks Sir

[@nhechao757]

Hi, is finance controller affair the same in most companies eg tech company vs manufacturing company. What I mean is that a financial controller will be easier to change companies than a accounting between different company. What do you think about this.

[@imthatguy4179]

Hello Bill. I have an excel file that has 2 sheets. Sheet 1 is the balance from sheet two. Sheet two data is a tracker of raw materials for all the days for a period (let’s say January). I will like to duplicate this two sheets for the month of February. I want the ending balance in January sheet two to automatically pop up in the February sheet two as the beginning balance. So that whenever January sheet 2 update , it automatically update also in February without having to do it manually. Can I use this function or what will you recommend

[@nadirbaig156]

How do the depresation work with formula.

[@shineeyadav9076]

Sir can you please suggest me any course that i should do to uplift myself and get a job in any good organization 🙏🙏🙏

[@TheFinancialController]

Hi Shinee. You should check out the Controller Bundle on my website

[@armies6498]

isnt this the same as xlookup?

[@TheFinancialController]

Yes

[@nicholasshook7513]

Anyone on here recommend a double major in accounting and MIS if I want to get my CPA? Or just focus strictly on accounting?

[@TheFinancialController]

I would focus on accounting

[@sandeepsmatharu]

Xlookup?

[@altai_iir7752]

Nice like xlookup

[@savissm]

Hi Bill , Can we approach this with xLookUp too ?

[@TheFinancialController]

Yes for sure

[@edwardbalani5031]

xlookup