# E9 | openai/gpt-5.4-mini | run 1

## Prompt

Write a spreadsheet formula that looks up the price of the product named in cell D2 from a table in columns A (names) and B (prices).

## Response

Use `XLOOKUP` if your spreadsheet supports it:

```excel
=XLOOKUP(D2, A:A, B:B)
```

If you need a compatible alternative, use `VLOOKUP`:

```excel
=VLOOKUP(D2, A:B, 2, FALSE)
```

Do you want the formula to return a blank or custom message if the product is not found?
