Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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?

Syntax of the MATCH function

Suppose you have a worksheet with 5,000 rows containing 5,000 names. You need to find the name John Doe, which you know appears ...