# E9 | openai/gpt-5.6-luna | 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:

```excel
=XLOOKUP(D2,A:A,B:B,"Not found")
```

This looks for the product name in `D2` within column A and returns its corresponding price from column B. If `XLOOKUP` is unavailable, use:

```excel
=IFERROR(VLOOKUP(D2,A:B,2,FALSE),"Not found")
```

Would you like the formula adapted for a specific spreadsheet application, such as Excel or Google Sheets?
