Use VLOOKUP for vertical lookups
Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Step 1: Identify the lookup_value, table_array, and column index number.
Step 2: Set range_lookup to TRUE (approximate match) or FALSE (exact match)
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com