Google Sheets will add the closing parenthesis and you should see the result in the cell. We didn't need to specify a sum_range because in this example it's just the same as the range.

This formula retrieves employee names (column D), departments (column Q), and performance scores (column AB), then sorts by ...

This builds on the other Gemini-powered feature in Sheets that can answer questions about your data and even create a visualization. However, the AI function comes with some limitations, as it ...

There's no wizard in Google Sheets, though, so you'll need to enter all the values manually. How to use VLOOKUP with Google Sheets The easiest way to understand how to use VLOOKUP is with an example.