Back to lesson
1. Microsoft documents that the syntax for MATCH is =MATCH(Lookup_Value, Lookup_Array, [Match_Type]). What is wrong with this syntax as it is stated?
The syntax implies that Match_Type is optional. It must be specified.
Lookup_Array must be a vector not an array (i.e. the range must consist of either one row or one column)
The default value for Match_Type is 1, not 0. However, modellers typically require this value to be zero.
2. The default setting of Match_Type in the MATCH function is 1. What does this mean?
The function will search for an approximate match (i.e. the largest value less than or equal to the value sought), provided the list is in strict ascending alphanumerical order.
The function will search for an approximate match (i.e. the smallest value greater than or equal to the value sought), provided the list is in strict descending alphanumerical order.
The function will search for the first exact match regardless of how the list is populated.
3. In this example, the formula in cell F7 is =MATCH(F6,B6:B16). What value will the output take?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement