Review the lookup_value and lookup_array used in the MATCH f…
Review the lookup_value and lookup_array used in the MATCH function in cell D3. What result will the function return? (Hint: Consider how the MATCH function works.) Documentation on the MATCH function MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required. The value that you want to match in lookup_array. The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value. lookup_array Required. The range of cells being searched. match_type Optional. The number -1, 0, or 1. The match_type argument specifies how Excel matches lookup_value with values in lookup_array.
Read Details