INDEX and MATCH combination for flexible lookups
Syntax: INDEX(array, MATCH(lookup_value, lookup_array, [match_type]))
Step 1: Identify the data range (array) to return a value from.
Step 2: Use MATCH function to find the relative position of the lookup_value in the lookup_array.
Step 3: Combine INDEX and MATCH functions to retrieve the desired value.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com