How to Do a VLOOKUP in Smartsheet
- George Apostolov
How to Do a VLOOKUP in Smartsheet: step-by-step guide
Inside Smartsheet's Grid View, select the cell where you wish to run the VLOOKUP formula and then type an 'Equals' (=) sign.
Type 'VLOOKUP' next, then select it from the suggested results.
After that, select the cell you wish to use for searching the value.
Head back to your VLOOKUP formula and type a comma to proceed further.
Subsequently, click 'Reference Another Sheet'.
Browse the list, then select the sheet you want to use.
Following that, select the column that contains the reference data.
Once done, click 'Insert Reference'.
Type a comma, then provide the column number you wish to use.
Next, specify your preferred match type.
Once done, review your formula and tap 'Enter' or 'Return' to run it.
After completing these steps, the VLOOKUP formula will be activated instantly.
Quick answer: 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.
About this Smartsheet tutorial
Execute a VLOOKUP in Smartsheet by selecting a cell, referencing another sheet, adding column details and match types, and running the formula. This guide shows how to do a VLOOKUP in Smartsheet in 12 steps, starting with "Inside Smartsheet's Grid View, select the cell where you wish to run the VLOOKUP formul..." and finishing with "After completing these steps, the VLOOKUP formula will be activated instantly". The interactive demo above is a click-through copy of the real Smartsheet interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to do a VLOOKUP in Smartsheet?
12 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Smartsheet data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Smartsheet. Related guides: How to Export Smartsheet Projects to Excel, How to Freeze a Column in Smartsheet and How to Freeze a Row in Smartsheet. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
