How to use Index and Match in Excel

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