MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (? ) for partial matches. Often, the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH.matchtype Optional. The number 1, 0, or 1. The matchtype argument specifies how Excel matches lookupvalue with values in lookuparray. The default value for this argument is 1. The following table describes how the function finds values based on the setting of the matchtype argument. excel+match
Description. The Microsoft Excel MATCH function searches for a value in an array and returns the relative position of that item. The MATCH function is a builtin function in Excel that is categorized as a LookupReference Function. It can be used as a worksheet function (WS) in Excel.
In Microsoft Excel, there are so many distinct lookupsreference functions that can help you find a certain value in a range of cells, and MATCH is one of them. Basically, it identifies a relative position or location of any item in a range of cells. However, the MATCH can do much more than its pure Excel provides many formulas for finding a particular string or text in an array. One such function is MATCH, in fact Match function is designed to do a lot more than this. Today we are going to learn how to use the Excel Match function.excel+match