VLOOKUP

Looks up a value in the first column of a range and returns a value from a specified column. Works with same-sheet ranges and cross-sheet references in curly braces.

Syntax

smartsheet-mastery

=VLOOKUP(search_value, {range}, column_index, false)

Example

smartsheet-mastery

=VLOOKUP([Product ID]@row, {Products Range}, 2, false)
=IFERROR(VLOOKUP([SKU]@row, {Catalog Range}, 3, false), "Not found")