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

The VLOOKUP function retrieves the matching price from column B for the product name in D2. It searches column A and returns the second column of the range. 

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

For newer Excel versions or Google Sheets, XLOOKUP offers improved flexibility with the same result.

Which spreadsheet application are you using this in?
