How to VLOOKUP in Smartsheet (Including Another Sheet)

Updated 2026-10-04

Smartsheet does support VLOOKUP — including looking up values in a completely different sheet through cross-sheet references. Here is the exact formula syntax, the sturdier INDEX/MATCH alternative most practitioners end up switching to, and what to do when formulas become the bottleneck.

Write a VLOOKUP against another sheet

Say each row has an Order ID and you want to pull that order's price from a separate Products sheet:

  1. Click the cell that should hold the result and start typing =VLOOKUP(.
  2. For the search value, use the current row's key: [Order ID]@row.
  3. When you reach the lookup table argument, click Reference Another Sheet in the formula help card, open the source sheet, and select the columns of the lookup table (key column leftmost).
  4. Finish the formula: =VLOOKUP([Order ID]@row, {Products Range 1}, 3, false) — the 3 means "return the third column of the selected range", and false forces an exact match.
  5. Press Enter, then drag-fill down or convert it to a column formula so every row looks itself up.

Why INDEX/MATCH usually wins

VLOOKUP uses a numeric position inside its selected range. Inserting or reordering columns within that range can change which field that position identifies. INDEX/MATCH references the lookup and return columns separately, reducing this risk; deleting referenced columns or misaligning the ranges can still break the lookup:

=INDEX({Products Price}, MATCH([Order ID]@row, {Products Order ID}, 0))

Cross-sheet references carry two separate ceilings, and they pull in opposite directions. A sheet may hold no more than 100 distinct cross-sheet references — and INDEX/MATCH spends two of those where VLOOKUP spends one, so on a sheet crowded with lookups VLOOKUP is the thriftier of the pair. But a single reference range is capped at 100,000 inbound cells, and that is where a wide whole-table VLOOKUP range hurts: two narrow single-column references pull a fraction of the cells. On large sheets, thousands of lookup formulas also slow saving and loading noticeably.

Look it up without formulas at all

Smartsheet’s native Column Links provide identifier-based cross-sheet lookups without formulas on Pro, Business and Enterprise. Set them up in Table View with Admin access to the target and at least Viewer access to the source. Use them when linked values should stay updated as the source changes.

Our Cross-Sheet Lookup tool instead matches rows by a key and writes values in a reviewed run. It does not create a continuously maintained link: re-run it when you want to refresh those values. Check the key and proposed changes in the preview before applying.

Official Smartsheet documentation: Column Links, VLOOKUP, Cross-sheet reference limits.

Do it in one pass instead

Pull matching values from one Smartsheet into another by key column — a sturdier alternative to fragile VLOOKUPs, with a preview before anything is written.

Try Cross-Sheet Lookups Free

Frequently asked questions

Does Smartsheet have VLOOKUP?

Yes. VLOOKUP supports exact-match lookups and cross-sheet references. INDEX/MATCH references lookup and return ranges separately, avoiding VLOOKUP’s fixed return-column position, but still requires valid, aligned ranges.

How do I reference another sheet in a Smartsheet formula?

While typing the formula, click "Reference Another Sheet" in the formula help card, open the source sheet and select the cells or columns to reference. Smartsheet saves it as a named range like {Products Range 1}.

Can I pull values from another sheet without formulas?

Yes. Native Column Links provide automatically maintained lookups by identifier without formulas. Our Cross-Sheet Lookup tool writes values in an explicit previewed run instead; re-run it when you want to refresh the results.