XLOOKUP function in Excel - Dashboard Guide

Dashboard Mode - XLOOKUP function

Goal

Find product prices quickly by looking up product names in a list.

Sample Data

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

Dashboard Components

• Input Cell: Cell D2 where user types a product name (e.g., "Banana")
• Price Result: Cell D3 shows the price using formula:
  =XLOOKUP(D2, A2:A6, B2:B6, "Not found")
  This looks for the product typed in D2 in the Product 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     |  Lookup Product  |
|  (A2:B6 Table)        |  [Input D2]      |
|                      |  Price: [D3]     |
+----------------------+------------------+

Interactivity

User types a product name in cell D2. The price in D3 updates automatically using the XLOOKUP formula. If the product is not in the list, it shows "Not found".

Self Check

If you type "Carrot" in D2, what price appears in D3? (Answer: 0.30)

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

Key Result

A simple dashboard to look up product prices by product name using XLOOKUP.