Skip to main content
Version: Streamsheets 2.4

MATCH

Returns a relative position number of a matching cell inside a specified cell range.

Syntax

=MATCH(Value, SearchRange [, Type])

Arguments

NameDescription
valueValue to search for.
SearchRangeA cell range to search in.
TypeOptional. Search type with the following options:
1: (Default) Find the largest value in cell range which is less than or equal to specified value. Table must be in ascending order.
0: Find the first value which match exactly specified value. Here the wildcards ? and * are supported.
-1: Find the smallest value in cell range which is greater or equal to specified value. Table must be in descending order.

Return Value

Returns relative position of in cell-range for given value or #NA if no match is found.

Example

FunctionResultComment
1. =MATCH(4,B2:B4, 0)
2. =MATCH(2,A2:B2, 0)

1. 2
2. 1
The index of the cell with the searched value is returned.