# E9 | mistralai/mistral-small-2603 | 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 this formula in your spreadsheet:

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

**Explanation**
- `D2` — cell containing the product name to look up.
- `A:B` — the table array where column A holds names and column B holds prices.
- `2` — the column index of the price (second column in the range A:B).
- `FALSE` — ensures an exact match.

For improved clarity in larger files, consider naming your range:

```excel
=VLOOKUP(D2, ProductTable, 2, FALSE)
```
where `ProductTable` refers to A:B.
