The LOOKUP Function
Use LOOKUP when you need to find something in a single row or column and find a value from the same position in a second row or column.
1804, 2019
Monthly Archives: April 2019
1804, 2019
The HLOOKUP Function
Use HLOOKUP when you need to find things in a table or a range by column. It is part of the lookup and reference functions of Excel .
1804, 2019
The VLOOKUP Function
Use VLOOKUP when you need to find things in a table or a range by row. It is part of the lookup and reference functions of Excel.
1804, 2019
The OFFSET Function
The OFFSET function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells .
1804, 2019
The MATCH Function
The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range .
1804, 2019
The INDEX Function
The INDEX function returns a value or the reference to a value from within a table or range.
1804, 2019
The CHOOSE Function
The CHOOSE function returns a value from an array of values, that corresponds to a specific position in that array.
1804, 2019
The SUMIFS Function
The SUMIFS function adds the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Mathematical functions of Excel.
1804, 2019
The COUNTIFS Function
The COUNTIFS function counts the number of times certain criterias are met. Even though its logical elements, it is part of the Statistical functions of Excel.
1804, 2019
The AVERAGEIFS Function
The AVERAGEIFS function returns the arithmetic mean (average) of all the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Statistical functions of Excel.
