(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.
Let's say you need to check if an email address appears in a long list of email addresses.
Use the MATCH function to return the row number on which the email address can be found. If there is no match, the function returns an #N/A error.
But you may not care what row number the email address is on - you just want to know if it exists, so we can wrap the MATCH function to either return Yes or Missing instead:
Say, you have a dataset consisting of names and email addresses. Now in another dataset, you just have the email address and wish to find the appropriate first name that belongs to that email address.
The MATCH function returns the appropriate row the email is at, and the INDEX function selects it. Similarly, this can be done for columns as well. When a value cannot be found, it will return an #N/A error.
This is very similar behaviour to VLOOKUP OR HLOOKUP, but much faster and combines both previous functions in one.