Returns the relative position of the given value in a given range.
Syntax
search_item: The value to search for in the given range. E.g. "Ming Yin"
search_region: The row/column to search. E.g. C2:C7
match_type: Determines how the given value is searched in the given range. Defaults to 1 if omitted.
-1 - search_region must be sorted in the descending order. Exact match or next greatest value is considered.
0 - search_region can be unsorted. Exact and regex match are considered.
1 and >2 - search_region must be sorted in the ascending order. Exact match or next smallest value is considered.
2 - search_region must can be unsorted. Exact match is considered.
Remarks
MATCH is case-insensitive, e.g. "APPLES" and "Apples" are treated similarly.
If you don't remember the complete text you have to search for, use .* after the initial characters. E.g. "Stand.*" for Standard Chairs
Examples
Formula |
Result |
=MATCH( "Ming Yin" ; C2:C7 ;0) |
4 |
=MATCH(3038; A2:A7 ;1) |
5 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com