The INDIRECT Function
It returns a formula as a string.
0205, 2019
Tag Archives: Reference
0205, 2019
The FORMULATEXT Function
It returns a formula as a string.
1804, 2019
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
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.
1704, 2019
How to use the LOOKUP Function
From all the lookup functions, LOOKUP is the least useful. Even though it is a powerful function, it is hardly used at all.