FIND Function
Returns the starting position of one text within another text.
CONCAT Function
Returns joined items as one text.
COUNTIFS Function
Returns a count of the number of rows that matches the criteria in criteria ranges.
SUMIFS Function
Returns sum of all values in the sum range for the rows that matches the criteria in criteria ranges.
VLOOKUP Function
Returns the value from the defined column and from the same row as the first match between lookup value and the leftmost column.
OFFSET Function
Returns the value from a cell that is a certain number of rows and columns from the reference cell.
MATCH Function
Returns the array position index of the first value in the array that matches the lookup value.
IFERROR Function
Returns the second argument if the first argument contains an error. Returns the first argument if no error is found.
IF Function
Returns second argument if the condition is met else it returns third argument.
