MATCH function in Excel - Dashboard Guide

Dashboard Mode - MATCH function

Goal

Find the position of a product in a list to quickly locate its row number for further analysis.

Sample Data

Product	Category	Price	Stock
Apple	Fruit	1.2	50
Banana	Fruit	0.5	100
Carrot	Vegetable	0.8	80
Dates	Dry Fruit	3.0	40
Eggplant	Vegetable	1.5	30

Dashboard Components

• Search Input: Cell G2 where user types a product name (e.g., "Carrot")
• Position Result: Cell G3 with formula =MATCH(G2, A2:A6, 0) to find the exact position of the product in the list.
• Product Details: Cells G5:G7 showing the product's Category, Price, and Stock using formulas:
  =INDEX(B2:B6, G3) for Category,
  =INDEX(C2:C6, G3) for Price,
  =INDEX(D2:D6, G3) for Stock.

Dashboard Layout

+----------------------+---------------------+
|      Product List     |   Search & Details  |
| +------------------+ | +-----------------+ |
| | Product | Category| | | Search: [ G2 ]   | |
| | Price   | Stock   | | | Position: [G3]   | |
| | ...     | ...     | | | Category: [G5]   | |
| +------------------+ | | Price:    [G6]   | |
|                      | | Stock:    [G7]   | |
+----------------------+---------------------+

Interactivity

User types a product name in cell G2. The MATCH formula in G3 finds the product's position in the list. The INDEX formulas in G5:G7 then show the product's details dynamically. Changing the product name updates all related cells automatically.

Self Check

If you change the product name in G2 to "Dates", what will be the position number in G3 and what details will appear in G5:G7?

Key Result

Dashboard finds a product's position in a list and shows its details using MATCH and INDEX formulas.