INDEX MATCH with Multiple Criteria
Learn the easy way to perform an INDEX MATCH with multiple criteria in Excel.
3 minute read
Michael Quach
Senior Instructor
Courses
Ready to explore our courses
Select the course that will take your career to the next level
14 hours
Excel for Business & Finance
Learn everything you need to know about Microsoft Excel from business and finance industry professionals.
15 hours
The Complete Finance & Valuation Course
Master the fundamentals of finance, valuation, financial modeling, and more!
14 hours
Power BI for Business Analytics
Master Power BI, the leading business intelligence tool to transform, analyze and visualize data.
14 hours
SQL for Business Analytics
Learn this in-demand database management language to extract, transform, and analyze databases with precision.
14 Hours
Python for Data Analysis
Learn the most popular programming language in the world and unlock the power to clean, analyze, and visualize data.
15 hours
VBA & Macros for Business Automation
Master Excel VBA & Macros to automate repetitive tasks, generate custom functions, and run complex operations.
13 hours
Financial Accounting Essentials
Learn the fundamentals of the balance sheet, income statement, cash flow statement, and financial statement analysis.
15 hours
LBO Modeling & Private Equity
Learn the PE industry insights and the LBO modeling skills to drive your private equity or investment banking career.
13 hours
Mergers & Acquisitions Modeling
Learn to make merger models exactly like an investment banker would using real companies to measure the accretion / dilution of a deal.
8 hours
Recruiting for Business & Finance Roles
Learn all the networking, application, and interview essentials to stand out and break into your dream role.
9 hours
PowerPoint for Business & Finance
Build professional PowerPoint pitch decks, presentations, and more using industry best practices.
7 hours
Word For Business & Finance
Create professional business reports and business documents in Microsoft Word with industry best practices.
5 hours
Outlook for Business & Finance
Learn to effectively manage your work communications with Outlook features such as email, calendar, and a to-do list.
100+ hours
All Access Course Bundle
Get unlimited access to all our courses for a discounted price.
This is some text inside of a div block.
The Data Analyst Program
Learn to import, clean, analyze, and visualize data with our hands-on case-study based curriculum and supercharge your data career.
This is some text inside of a div block.
The Investment Banking Program
Learn the essential Excel, accounting, valuation, LBO, and M&A modeling skills to level up your finance career.
5 hours
Outlook for Business & Finance
Learn to effectively manage your work communications with Outlook features such as email, calendar, and a to-do list.
7 hours
Word For Business & Finance
Create professional business reports and business documents in Microsoft Word with industry best practices.
9 hours
PowerPoint for Business & Finance
Build professional PowerPoint pitch decks, presentations, and more using industry best practices.
8 hours
Recruiting for Business & Finance Roles
Learn all the networking, application, and interview essentials to stand out and break into your dream role.
15 hours
VBA & Macros for Business Automation
Master Excel VBA & Macros to automate repetitive tasks, generate custom functions, and run complex operations.
13 hours
Financial Accounting Essentials
Learn the fundamentals of the balance sheet, income statement, cash flow statement, and financial statement analysis.
15 hours
LBO Modeling & Private Equity
Learn the PE industry insights and the LBO modeling skills to drive your private equity or investment banking career.
13 hours
Mergers & Acquisitions Modeling
Learn to make merger models exactly like an investment banker would using real companies to measure the accretion / dilution of a deal.
14 hours
Power BI for Business Analytics
Master Power BI, the leading business intelligence tool to transform, analyze and visualize data.
14 hours
SQL for Business Analytics
Learn this in-demand database management language to extract, transform, and analyze databases with precision.
14 Hours
Python for Data Analysis
Learn the most popular programming language in the world and unlock the power to clean, analyze, and visualize data.
15 hours
The Complete Finance & Valuation Course
Master the fundamentals of finance, valuation, financial modeling, and more!
14 hours
Excel for Business & Finance
Learn everything you need to know about Microsoft Excel from business and finance industry professionals.