INDEX-MATCH combination in Excel - Dashboard Guide

Dashboard Mode - INDEX-MATCH combination

Goal

Find the sales amount for a specific product using a flexible lookup method.

Sample Data

Product	Sales	Region
Apples	120	North
Bananas	150	South
Cherries	90	East
Dates	200	West
Elderberries	80	North

Dashboard Components

• Input Cell: Cell F2 where user types the product name to search (e.g., "Bananas").
• Result Cell: Cell F3 with formula to find sales for product typed in F2.
• Formula in F3: =INDEX(B2:B6, MATCH(F2, A2:A6, 0))
  This formula looks for the product typed in F2 in the Product list (A2:A6), finds its position, then returns the sales from B2:B6 at that position.

Dashboard Layout

+----------------------+------------------+
| Product List         | Sales            |
| Apples               | 120              |
| Bananas              | 150              |
| Cherries             | 90               |
| Dates                | 200              |
| Elderberries         | 80               |
+----------------------+------------------+

+-----------------------------+
| Enter Product: [ F2 ]        |
| Sales Found:   [ F3 ]        |
+-----------------------------+

Interactivity

User types a product name in cell F2. The formula in F3 updates automatically to show the sales for that product. If the product is not found, the formula will return an error.

Self Check

Type "Dates" in cell F2. What number appears in F3? (Expected: 200)

Key Result

Lookup sales for a product using INDEX-MATCH based on user input.