MAP Function Explained
The MAP function in Microsoft Excel is used to look up a value in a given range and return a corresponding value from another range. It takes three arguments: lookup_value, map_lookup_range, and result_range. The lookup_value is the value to be looked up in the map_lookup_range, and the result_range is the range of values that will be returned if the lookup_value is found.
MAP Function Syntax
MAP(array1, array2, array3, ...)
- array1: The first array of values to be mapped.
- array2: The second array of values to be mapped.
- array3: The third array of values to be mapped.
- …: Additional arrays of values to be mapped.