match_type is an optional value that defines the type of match you are looking for.lookup_array is the range of cells that contain the list.lookup_value is the value you want to find in the list.=MATCH( lookup_value,lookup_array,match_type) The MATCH() function has the following syntax: This lesson explains how to use the MATCH() function in Microsoft Excel, explains where you might use it, and provides a real world example of the MATCH() function in action. For example, in a list of weekdays starting with Monday first, MATCH() would return a value of 3 for Wednesday. The MATCH() function allows you to find the relative position of a value in a list in Excel.
