Tackle 2024 with new knowledge – take advantage of Learnesys’ fall campaign on the All Courses package. Read more here.
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.