How to Do a VLOOKUP in Smartsheet

Quick summary

The VLOOKUP formula in Smartsheet lets you search for a value in one sheet and pull matching data from another sheet automatically. This step-by-step walkthrough covers how to build a cross-sheet VLOOKUP from selecting your lookup cell to inserting a sheet reference and running the formula.

Steps

1. In Smartsheet's Grid View, select the cell where you want to run the VLOOKUP formula, then type an equals sign (=).
2. Type VLOOKUP and select it from the suggested formula results.
3. Select the cell you want to use as the lookup value for the search.
4. Return to your VLOOKUP formula and type a comma to continue building the formula.
5. Click Reference Another Sheet to set up a cross-sheet reference.
6. Browse the list and select the sheet you want to reference.
7. Select the column that contains the reference data (e.g., the COMMODITY column).
8. Click Insert Reference to add the sheet reference to your formula.
9. Type a comma, then enter the column number you want to return data from.
10. Specify your preferred match type (e.g., 0 for exact match).
11. Review your completed VLOOKUP formula, then press Enter or Return to run it.
12. The VLOOKUP formula activates instantly and pulls the matched value into your cell.