The syntax for the MATCH function is as follows. The MATCH Function checks for a particular value in a range of cells and returns the respect location of that value. MATCH lookup_value lookup_array match_type Lookup_value required - the value you want to find.
Here we will be using a formula that contains the INDEX and MATCH Function.
MATCH supports approximate and exact matching and wildcards for partial matches. When you enter a value in cell B2 the first argument VLOOKUP searches the cells in the range C2E7 2nd argument and returns the closest approximate match from the third column in the range column E 3rd argument. Excel provides many formulas for finding a particular string or text in an array. You will see a pair of.