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

the largest value in the table
the smallest value in the table
O the largest value that is less than the lookup value
the smallest value that is greater than the lookup value

User Ymi
by
7.8k points

1 Answer

4 votes

Answer:

Its C

Step-by-step explanation:

The largest value that is less then the lookup value

User Jasmin Sojitra
by
8.6k points

Related questions