Dashboard Mode - VLOOKUP function
Goal
Find product prices quickly by looking up product names in a list.
0
0
VLOOKUP function in Excel - Dashboard Guide
Sample Data
| Product | Price |
|---|---|
| Apple | 1.20 |
| Banana | 0.50 |
| Carrot | 0.30 |
| Date | 1.50 |
| Eggplant | 0.80 |
Dashboard Components
- Input Cell: Cell E2 where user types a product name (e.g., "Banana")
- Price Lookup Result: Cell E3 shows the price using formula
=VLOOKUP(E2, A2:B6, 2, FALSE). This finds the exact price for the product typed in E2. - Product List Table: Shows all products and prices from A2:B6 for reference.
Dashboard Layout
+-------------------+-------------------+ | Product List | Lookup Input & | | (A2:B6) | Price Result | | | | | Apple 1.20 | Product: [ E2 ] | | Banana 0.50 | Price: [ E3 ] | | Carrot 0.30 | | | Date 1.50 | | | Eggplant 0.80 | | +-------------------+-------------------+
Interactivity
User types a product name in cell E2. The formula in E3 updates automatically to show the matching price from the product list. If the product is not found, the formula returns an error.
Self Check
Type "Carrot" in cell E2. What price appears in E3? (Expected: 0.30)
Key Result
Dashboard to look up product prices by typing product names using VLOOKUP.