# E9 | x-ai/grok-4.3 | 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

The most common formula for this exact lookup task is `=VLOOKUP(D2,A:B,2,FALSE)`. It returns the price from column B that matches the product name in D2.  

## Recommended Formula
```
=VLOOKUP(D2,A:B,2,FALSE)
```

This works in Excel, Google Sheets, and LibreOffice Calc. It performs an exact match and assumes your data table begins at the top of columns A and B.

## Alternative Formula
```
=INDEX(B:B,MATCH(D2,A:A,0))
```
This option is more flexible if you later insert columns or prefer to avoid VLOOKUP limitations.

What range or spreadsheet application are you using?
