Index and Match functions can help you locate a specific item in an Excel worksheet. In this lesson, I'll show you how to use the Index and Match functions in Excel. We'll go over how to use the Index function, the match function, and at the end we'll put the Index and Match functions together to solve a unique challenge. DOWNLOAD THE PRACTICE FILES HERE: https://www.patreon.com/MikesOffice

Create a status bar in Excel with formulas!
27.1K views

Convert Word to PDF from Laptop
81.8K views

This Excel practice exam was saved by....
21.9K views

Secret Excel Exam Project 3 (auto gallery)
8.0K views

Easily Share a Word doc like a Google Doc
35.8K views

Excel Exam Secrets (Part 2) from a Canadian
9.6K views