It can be any one of these values: 1, 0, -1. Match_type (optional) – explains the match type.Lookup_array (required) – search from the range of cells.It can be either numeric, text or logical value as well as a cell reference. Lookup_value (required) – the value you are searching for.The Formula for the MATCH function is as follows: The MATCH Function checks for a particular value in a range of cells and returns the respective location of that value. Most of the time, the INDEX function is integrated with a MATCH function to retrieve the value at the location returned by MATCH.
MATCH finds approximate and exact matches and wildcards (* ?) for limited matches. The MATCH function is used to search the location of a lookup value in a table or a row column.
Excel functions, formula, charts, formatting creating excel dashboard & others
