Back to all functions

In this lesson, we will be going through the VLOOKUP function.
VLOOKUP looks for a given value in the column furthest to the left, and returns a value in a different column, on the same row.
We’ll write Equals VLOOKUP. The function consists of four arguments: What we are looking for inside the table, which is in cell B4, the table area… which column, counting from the left, we have our desired return value, which is the third, and TRUE or FALSE depending on whether we want an exact or approximate match, so we’ll write FALSE, for exact.
We’ll then make the table area an absolute reference so that we can copy the formula downward and get the result for each order number specified.
This lesson has gone through the VLOOKUP function, which is useful when trying to locate certain values in a table.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.