# How to Do a VLOOKUP in Smartsheet

> To perform a VLOOKUP in Smartsheet, select a cell in Grid View, type equals and VLOOKUP, choose the search cell, and reference another sheet. Next, select the reference column, insert the reference, add the column number and match type, and press Enter to run the formula.

Canonical: https://livedemo.ai/tutorials/how-to-do-a-vlookup-in-smartsheet/
Apps: Smartsheet
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3badab56e05a00fe3207/preview?step=1

## Steps

1. Inside Smartsheet's Grid View, select the cell where you wish to run the VLOOKUP formula and then type an 'Equals' (=) sign.
2. Type 'VLOOKUP' next, then select it from the suggested results.
3. After that, select the cell you wish to use for searching the value.
4. Head back to your VLOOKUP formula and type a comma to proceed further.
5. Subsequently, click 'Reference Another Sheet'.
6. Browse the list, then select the sheet you want to use.
7. Following that, select the column that contains the reference data.
8. Once done, click 'Insert Reference'.
9. Type a comma, then provide the column number you wish to use.
10. Next, specify your preferred match type.
11. Once done, review your formula and tap 'Enter' or 'Return' to run it.
12. After completing these steps, the VLOOKUP formula will be activated instantly.