If the VLOOKUP function is used to find an approximate match, what will it return if there is no exact match?

With approximate match, VLOOKUP returns the row for the largest value in the first column that is less than or equal to the lookup value. So if there is no exact match, it returns the largest value below the lookup value, making C correct. This assumes the lookup column is sorted in ascending order.

AI-written and checked against the verified answer.