Question

What does C4 refer to in the function =MATCH(C4,earnings,-1)?

A. The search row
B. The named range
C. The lookup value
D. The match type

Answer 1

The match type

Step-by-step explanation:

This command is used to find the smallest value from lookyp array that is larger than look up value. lookup value in lookup array.

This command is look like:

=Match (Lookup Value,lookup array, match type)

in given example

lookup value is C4, Lookup Array is earnings and -1 is match type.

due to -1,

this function find the value from earnings that is smallest in array but larger than C4.