# E9 | openai/gpt-5.6-luna | run 2

## 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
=VLOOKUP(D2,A:B,2,FALSE)
```

This looks for the product name in `D2` in column A and returns its corresponding price from column B. `FALSE` requires an exact match.

In newer Excel or Google Sheets, you can also use:

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

Would you like the formula adapted to a specific spreadsheet app?
