(Optional) Every topic has a focus. Tell the readers what they will find here and let future contributors know what belongs.
|lookup_value||The value you want to match. Can be either a fixed value, cell reference or named range. Strings may not exceed 255 characters (required)|
|lookup_array||The cell reference (or named range) that you want to search, this can either be a row or a column sorted in ascending order for default type 1 matches; desceding order for -1 type matches; or any order for type 0 matches (required)|
|match_type||Controls the way the search works. Set to 0 if you only want exact matches, set to 1 if you want to match items less than or equal to your lookup_value, or -1 if you want to match items greater than or equal to your lookup_value. (Optional - defaults to 1)|
Use the MATCH function to check if (and where) a value can be found in a list. Often seen as a parameter return for the row and/or column in INDEX(array, row, column) function. Allows negative row/column references allowing left or above lookups.