Type the column number for Height which is 2 and close the bracket. But the values are in ascending order and that causes the NA error. VLOOKUP 07A2C103FALSE Using an exact match searches for the value 07 in column A.
This is because INDEX and MATCH is incredibly flexible you can do horizontal and vertical lookups 2-way lookups left lookups case-sensitive lookups and even lookups based on multiple criteria.
For example if the range A1A3 contains the values 5 25 and 38 then the formula MATCH25A1A30 returns the number 2 because 25 is the second item in the range. For example if the range A1A3 contains the values 5 25 and 38 then the formula MATCH25A1A30 returns the number 2 because 25 is the second item in the range. In the example we are using the following formula INDEXdataMATCHTRUEEXACTF4 B3B10203 This formula is an array formula and must be entered with Control Shift Enter. INDEX data_array MATCH vlookup_value lookup_column_range 0 MATCH hlookup value lookup_row_range 0.