Excel Tutorial Match Function

The excel match function search a value in an array and returns the position of that item.

Excel tutorial match function. The match function returns the position of a value in a given range. Match supports approximate and exact matching and wildcards for partial matches. Type match and link to the cell containing kevin the name we want to look up select all the cells in the name column including the name header type zero 0 for an exact match the result is that kevin is in row 4. Match lookup value lookup array match type.

Match is an excel function used to locate the position of a lookup value in a row column or table. Heres an example of how match works by itself using the following syntax. The match function is a build in function in microsoft excel and it is categorized as a lookup and reference function. The match function in excel just returns the index of first appearance of a value in an array single dimension.

Try using the new xmatch function an improved version of match that works in any direction and returns exact matches by default making it easier and more convenient to use than its predecessor. Match h1a2a130 is the first item solved in this formula. The match function is a built in function in excel that is categorized as a lookupreference function. The match function searches for a specified item in a range of cells and then returns the relative position of that item in the range.

For example the match function below looks. Match h2b1e10 is the second match formula and its really similar to the first but is instead looking for h2 the. Description the microsoft excel match function searches for a value in an array and returns the relative position of that item. Lets learn the match function syntax and illustrate how to use the function in excel below.

The match function is available in excel 2016 excel 2013 excel 2010 excel 2007 excel 2003 excel xp excel 2000 excel 2011 for mac. Match function in excel. The index function below returns a specific value in a one dimensional range. Check the excel essentials course.

The match function in excel the match function finds the row or column number of an item in a range of cells and then it passes those row and column numbers into index. We can now rewrite the index formula like this to. Its looking for h1 the word may in a2a13 to get a. Replace the value 5 in.

This function is mostly associated with the index function often known as the index match function.