Skip to main content
Version: Streamsheets 3.0

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

NameTypeDescription
ValueNumberThe value to look for in the first column of a table.
TableRangeRange to look in. The table from which to retrieve a value.
Col_IndexNumberThe column in the table from which to retrieve a value.
Range_LookupNumberOptional TRUE = approximate match (default). FALSE = exact match.

Return

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

Examples

AB
1Test13
2Test24
3Test33
FormulaResultComment
=VLOOKUP("Test3",A1:B3, 2)
3The value of cell B3 within the given range is returned.