| VLOOKUP | =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. By default, the table must be assorted in ascending order. |
| INDEX | =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 |
| MATCH | =MATCH(lookup_value, lookup_array, [match_type]) | Returns the relative position of an item in an array that matches a specified value in a specified order |
| Wildcards | “*” | Usually followed or preceded by the concatenation & to be used for lookups or formulas. |
