ASSIGNMENT – 19
INDEX with MATCH — Answer Key
Data Range
-
Region:
A2:A6 -
Sales Data:
B2:E6 -
Month Headers:
B1:E1
Answers
| Q. | Question | Answer | INDEX + MATCH Formula |
|---|---|---|---|
| 1 | March Sales of East | 6,750 | =INDEX(B2:E6,MATCH("East",A2:A6,0),MATCH("Mar",B1:E1,0)) |
| 2 | February Sales of West | 4,620 | =INDEX(B2:E6,MATCH("West",A2:A6,0),MATCH("Feb",B1:E1,0)) |
| 3 | January Sales of Central | 8,150 | =INDEX(B2:E6,MATCH("Central",A2:A6,0),MATCH("Jan",B1:E1,0)) |
| 4 | April Sales of North | 7,820 | =INDEX(B2:E6,MATCH("North",A2:A6,0),MATCH("Apr",B1:E1,0)) |
| 5 | March Sales of South | 11,450 | =INDEX(B2:E6,MATCH("South",A2:A6,0),MATCH("Mar",B1:E1,0)) |
| 6 | April Sales of East | 9,540 | =INDEX(B2:E6,MATCH("East",A2:A6,0),MATCH("Apr",B1:E1,0)) |
| 7 | January Sales of West | 3,850 | =INDEX(B2:E6,MATCH("West",A2:A6,0),MATCH("Jan",B1:E1,0)) |
| 8 | February Sales of Central | 7,250 | =INDEX(B2:E6,MATCH("Central",A2:A6,0),MATCH("Feb",B1:E1,0)) |
| 9 | March Sales of North | 9,150 | =INDEX(B2:E6,MATCH("North",A2:A6,0),MATCH("Mar",B1:E1,0)) |
| 10 | April Sales of Central | 9,850 | =INDEX(B2:E6,MATCH("Central",A2:A6,0),MATCH("Apr",B1:E1,0)) |
Final Answer Table
| Region | Month | Sales |
|---|---|---|
| East | March | 6,750 |
| West | February | 4,620 |
| Central | January | 8,150 |
| North | April | 7,820 |
| South | March | 11,450 |
| East | April | 9,540 |
| West | January | 3,850 |
| Central | February | 7,250 |
| North | March | 9,150 |
| Central | April | 9,850 |