0
0
Google Sheetsspreadsheet~8 mins

INDEX and MATCH combination in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - INDEX and MATCH combination
Goal

Find the price of a product by its name using INDEX and MATCH formulas combined.

Sample Data
ProductCategoryPrice
AppleFruit1.20
BananaFruit0.80
CarrotVegetable0.50
BroccoliVegetable1.00
MilkDairy1.50
Dashboard Components
  • Input Cell: Cell G2 where user types a product name (e.g., "Banana").
  • Price Lookup Formula: Cell G3 uses the formula =INDEX(C2:C6, MATCH(G2, A2:A6, 0)) to find the price of the product typed in G2.
  • Explanation: MATCH finds the row number where the product name matches the input. INDEX returns the price from that row.
Dashboard Layout
+----------------------+------------------+
| Product Name Input   | [ G2: "Banana" ] |
+----------------------+------------------+
| Price Result         | [ G3: 0.80 ]      |
+----------------------+------------------+
Interactivity

User types a product name in cell G2. The formula in G3 updates automatically to show the price of that product. If the product name is not found, the formula returns an error.

Self Check

If you change the product name in G2 to "Milk", what value appears in G3?

Answer: 1.50

Key Result
Lookup product price by name using INDEX and MATCH in Google Sheets.