XLOOKUP function in Google Sheets - Dashboard Guide

Dashboard Mode - XLOOKUP function

Goal

Find the price of a product by its name quickly and accurately.

Sample Data

Product	Price
Apple	1.20
Banana	0.50
Carrot	0.30
Date	1.50
Eggplant	0.80

Dashboard Components

• Input Cell: Cell B8 where user types a product name (e.g., "Banana").
• Price Result: Cell B9 shows the price using formula:
  =XLOOKUP(B8, A2:A6, B2:B6, "Not found")
  This looks for the product typed in B8 in the list A2:A6 and returns the matching price from B2:B6. If not found, it shows "Not found".
• Product List Table: Shows all products and prices for reference.

Dashboard Layout

+----------------------+------------------+
| Product List         |                  |
| +--------------+     |                  |
| | Product |Price|     |                  |
| | Apple   | 1.20|     |                  |
| | Banana  | 0.50|     |                  |
| | Carrot  | 0.30|     |                  |
| | Date    | 1.50|     |                  |
| | Eggplant| 0.80|     |                  |
| +--------------+     |                  |
+----------------------+------------------+
| Enter Product Name: B8                  |
| Price Found:          B9                |
+----------------------------------------+

Interactivity

User types a product name in cell B8. The XLOOKUP formula in B9 updates automatically to show the price of that product. If the product is not in the list, it shows "Not found". This lets the user quickly check prices without searching manually.

Self Check

If you type "Date" in cell B8, what price appears in B9? (Answer: 1.50)

If you type "Orange" in B8, what appears? (Answer: Not found)

Key Result

A simple dashboard to find product prices by name using XLOOKUP in Google Sheets.