Look Up Functions
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]): Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.
Example: =VLOOKUP(A1, C1:E10, 3, FALSE).
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]): Horizontal lookup. Searches for a value in the top row of a table and returns a value in the same column from a row you specify.
Example: =HLOOKUP(A1, C1:E10, 3, FALSE).
INDEX(array, row_num, [column_num]): Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
Example: =INDEX(B1:D10, 5, 2) returns the value in the fifth row and second column of B1:D10.
MATCH(lookup_value, lookup_array, [match_type]): Returns the relative position of an item in an array that matches a specified value.
Example: =MATCH(A1, B1:B10, 0) finds the relative position of A1 in B1:B10.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com