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

The match type

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.