Use HLOOKUP for horizontal lookups
Syntax: HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Step 1: Identify the lookup_value, table_array, and row index number.
Step 2: Set range_lookup to TRUE (approximate match) or FALSE (exact match).
Step 3: Enter the formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com