Tag Archives: Lookup Functions

The GETPIVOTDATA Function

Kornilios Ampatzis/ May 3, 2019/ Functions

It returns data stored in a PivotTable. You can use GETPIVOTDATA to retrieve summary data from a PivotTable, but only if the summary data is visible in the report.

The LOOKUP Function

Kornilios Ampatzis/ April 18, 2019/ Functions

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.

The HLOOKUP Function

Kornilios Ampatzis/ April 18, 2019/ Functions

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 .

The VLOOKUP Function

Kornilios Ampatzis/ April 18, 2019/ Functions

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.

The OFFSET Function

Kornilios Ampatzis/ April 18, 2019/ Functions

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 .

The MATCH Function

Kornilios Ampatzis/ April 18, 2019/ Functions

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 .

The INDEX Function

Kornilios Ampatzis/ April 18, 2019/ Functions

The INDEX function returns a value or the reference to a value from within a table or range.

The CHOOSE Function

Kornilios Ampatzis/ April 18, 2019/ Functions

The CHOOSE function returns a value from an array of values, that corresponds to a specific position in that array.

Advanced Lookup Functions Combinations: Part 3

Kornilios Ampatzis/ April 17, 2019/ Tutorials

We have reached the end of our quest for the best lookup function, where we will talk about the combination of INDEX and MATCH. In the current lesson, we will use INDEX with dual MATCH functions, to achieve a matrix lookup functionality. But you can easily skip one of the two MATCH functions, and replace it with a static value if you are not interested in a matrix lookup.

Advanced Lookup Functions Combinations: Part 2

Kornilios Ampatzis/ April 17, 2019/ Tutorials

We will continue our quest for the best lookup formula with another combination. We will use an OFFSET and two MATCH functions to do a matrix lookup. Unfortunately, this formula also only searches from the right column to the left and from the top to the bottom, but is very easy to understand and use.