Tag Archives: VLOOKUP

1804, 2019

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.

1704, 2019

Advanced Lookup Functions Combinations: Part 1

Kornilios Ampatzis/ April 17, 2019/ Tutorials

We will begin a quest to find the best lookup function. All the internal functions of Excel have limitations which we will try to overcome. In this and the following tutorials, the knowledge of the simple syntax of the functions mentioned (VLOOKUP, HLOOKUP, MATCH), is considered a requirement.

1704, 2019

How to use the VLOOKUP function

Kornilios Ampatzis/ April 17, 2019/ Tutorials

When you start learning about the lookup functionality of Excel, VLOOKUP will probably be one of the first functions you will stumble upon.