MATCHlookup_value lookup_array match_type lookup_value a value which we want to find in the lookup_array. 4 The INDIRECT function which will convert the TEXT version of the cell reference created by the ADDRESS function to a usable cell reference for the SUM function. So for example the first index returns B2 and the second index returns F2 so you get.
When index is used with the.
The INDEX function takes the number as the column index for the data and returns the array 92. Index and Match with Sum having 2 columns. So for example the first index returns B2 and the second index returns F2 so you get. Index and Match with Sum having 2 columns.