Level 2LookupsPractice, 4 min
INDEX and MATCH, two ways
The task
Leads by campaign and month. In G3, return the leads for the campaign in G1 and the month in G2. Use
MATCH twice, once for the row and once for the column, inside INDEX.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Campaign | Jan | Feb | Mar | Campaign | Brand Search | |
| 2 | Brand Search | 412 | 398 | 455 | Month | Feb | |
| 3 | Competitor | 96 | 121 | 133 | Leads | ||
| 4 | Retargeting | 210 | 187 | 240 | |||
| 5 | Webinar | 55 | 140 | 72 | |||
| 6 | Partner | 38 | 44 | 51 |