Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 5

The MATCH function

Questions answered in this chapter:

• Given monthly sales for several products, how do I write a formula that returns the sales of a product during a specific month? For example, how much of Product 2 did I sell during June?

• Given a list of baseball players’ salaries, how do I write a formula that yields the player with the highest salary? How about the player with the fifth-highest salary?

• Given the annual cash flows from an investment project, how do I write a formula that returns the number of years required to pay back the project’s initial investment cost?

• Can the XLOOKUP function be used to perform a two-way lookup?

Syntax of the MATCH function

Suppose you have a worksheet with 5,000 rows containing 5,000 ...