SUMIFS function adds the cell values based on specified criteria.
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”
Function Type: Logical Description: IF is one of the most popular functions in Excel. It checks if the condition is met then it returns a value. It is used to return one value if the logic is true and another value if false. Function Structure: =IF(logical_test, [value_if_true], [value_if_false]) Argument Breakdown: logical_test – This is whereContinue reading “IF function”
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”