Excel is an indispensable tool for anyone who works with data. It is widely used by business analysts, accountants, and data scientists to organize, analyze, and visualize data. One of the most useful features of Excel is VLOOKUP, which allows you to quickly look up and retrieve data from a table. If you're not familiar with VLOOKUP, don't worry - it's easy to learn and use. In this article, I will show you how to do a VLOOKUP in Excel.
Before we get into how to do a VLOOKUP in Excel, let's first understand the basics of VLOOKUP. VLOOKUP stands for "vertical lookup" and it is used to look up a value in a table and return a corresponding value from the same row. The VLOOKUP function has four arguments or inputs:
With this basic understanding of VLOOKUP, let's move on to how to do a VLOOKUP in Excel.
Before we can do a VLOOKUP in Excel, we need to set up the data. For this example, we'll use a simple table of sales data. The table has three columns: Product, Salesperson, and Sales.
Now that we have the data set up, we're ready to do a VLOOKUP.
To do a VLOOKUP in Excel, you need to write a formula that uses the VLOOKUP function. Here's the formula we'll use:
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Let's break this down:
Putting it all together, our VLOOKUP formula looks like this:
=VLOOKUP("Product A", A2:C5, 3, FALSE)
Now let's see the result of this formula.
Now that we have our VLOOKUP formula, let's see what it returns. Here's the formula in action:
As you can see, the formula returns the sales for Product A, which is $1000. Now let's do one more example.
In some cases, you may need to do a VLOOKUP with multiple criteria. For example, let's say you want to look up the sales for Product A for Salesperson B. Here's how you would do that:
=VLOOKUP("Product A"&"Salesperson B", A2:C5, 3, FALSE)
Notice that we use the ampersand (&) to concatenate the two criteria. This formula returns the sales for Product A and Salesperson B, which is $250. And there you have it - a VLOOKUP with multiple criteria!