To write the formula combining the two we use the MATCH function to for the row_num argument. Depending on the formula the return value of INDEX may be used as a reference or as a value. MATCH lookup_value lookup_array 0.
Heres the revised formula with the MATCH function nested inside.
MATCH finds the largest value that is less than or equal to lookup_value. In the example above I used a 4 for the row_num argument for INDEX. To write the formula combining the two we use the MATCH function to for the row_num argument. The MATCH function returns 5 because the lookup value peach is in the 5th position in the range B6B14.