Column Index Number: This is the column number in the table array from which you want to retrieve a value. The first column is 1, the second column is 2, and so on.

Enter the formula =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)). Replace return_range with the range of cells that contains the data you want to return. Replace lookup_value with the ...

Value: Explanation: 0: Find an exact match; return #N/A if none found. This is the argument’s default value.-1: Find an exact match; return the next smaller item if no match is found.