INDEX function

Function Type: Lookup and Reference Description: INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location of the lookup_value. Function Structure:  =INDEX(array, row_number, [column_number]) Argument Breakdown: array – This is the group of cells where your excelContinue reading “INDEX function”

VLOOKUP

Function Type: Lookup and Reference Description: VLOOKUP is one of the most popular functions in Excel. It is used to lookup a data and retrieve the corresponding data from a specific column. You may either lookup for the exact or approximate match. The “V” in Vlookup means Vertical. Function Structure:  =VLOOKUP(lookup_value, table_array, column_index_number, [range_lookup]) ArgumentContinue reading “VLOOKUP”