Skip to main content
Version: Streamsheets 2.5

VLOOKUP

Returns the value of a cell within a specified cell range in a chosen row and characteristic.

Syntax

=VLOOKUP(Value, Table, Col_Index, Range_Lookup)

Arguments

NameDescription
ValueThe value to look for in the first column of a table.
TableRange to look in. The table from which to retrieve a value.
Col_IndexThe column in the table from which to retrieve a value.
Range_LookupOptional TRUE = approximate match (default). FALSE = exact match.

Return

Value of cell within the given range and index or offset, if a row with the value was found.

Examples

FormulaResultComment
=VLOOKUP("Test3",[object Object], 2)[object Object][object Object] [object Object]
3The value of cell B3 within the given range is returned.