What type of result does the MATCH function, when used on its own, return?


It returns the lookup value located in a specific location.

It returns a value that is the same as the lookup value.

It returns the cell reference of the lookup value.

It returns the relative position of a lookup value, either as a row or column number, within the selected array.

Respuesta :

Answer:

D: It returns the relative position of a lookup value, either as a row or column number, within the selected array

Explanation:

In Microsoft, the MATCH function is a function that is easily used to look for a specific item in a range of cells, and thereafter it now returns the relative position of that item in that same range of cells.

Thus, the correct answer is Option D