Question

option under the File
5. Click the
Match the columns.
Components of
Functior​

Answer 1

Answer:

=MATCH(lookup_value, lookup_array, [match_type])

 

The MATCH formula uses the following arguments:

Lookup_value (required argument) – This is the value that we want to look up.

Lookup_array (required argument) – The data array that is to be searched.

Match_type (optional argument) – It can be set to 1, 0, or -1 to return results as given below:

Explanation: