VLOOKUP

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.