IntermediateLookup & Reference
Look up a customer's region with XLOOKUP
Match a customer ID against a reference table to return their region.
XLOOKUP
8 min25 points
Name the best-performing campaign
The situation
Harbor Supply's marketing lead opens every monthly review with the campaign that did best. The export is never sorted the same way twice, and scanning a column by eye for the largest number is how the wrong campaign got named last month.
A1
fx
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Campaign | Conversions | ||||
| 2 | Spring Catalog | 340.00 | Best campaign | |||
| 3 | Trade Show Q3 | 180.00 | ||||
| 4 | Reorder Reminder | 520.00 | ||||
| 5 | Search Brand | 410.00 | ||||
| 6 | Winter Preview | 95.00 | ||||
| 7 | Retarget Cart | 260.00 | ||||
| 8 | Distributor Mailer | 150.00 | ||||
| 9 | Welcome Series | 300.00 | ||||
| 10 |
Functions in this exercise
- INDEX — Returns the value at a given row and column position in a range. Syntax and example
- MATCH — Returns the position of a value within a range. Syntax and example
- MAX — Returns the largest number in a range. Syntax and example
Who this is for
Recommended next
Related exercises
- AdvancedLookup & Reference
Name the third-fastest supplier
Return a name from one column based on a ranked value in another.
INDEX · MATCH · SMALL
13 min40 points - AdvancedData Analysis
Name the second-best rep with LARGE and INDEX
Combine ranking with a lookup to return a name, not just a number.
LARGE · INDEX · MATCH
14 min40 points - BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points