From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using VLOOKUP with large tables

Using VLOOKUP with large tables

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using VLOOKUP with large tables

- If you're trying to pull together data from different lists that have similar information, you're probably going to be using the VLOOKUP function. Imagine these two lists here. They're on the same worksheet right now, maybe they were on different worksheets, and certainly what we're about to do could be done from different worksheets, but to see the data side by side sometimes is helpful. In this list to the right, we'd like to pick up the Salary for each person, and we're assuming that most of the Social Security numbers that we see here are going to be found in the other list. We'd like to know the Salary for these people here. So, we can start with the vlookup, recognizing that in both lists, we see Social Security numbers. So here's a Social Security number right here, comma, and we want to find that in the other list and ultimately come back with the Salary, so when we refer to the other list, let's just select columns A, B and C. We're not going to be using the dependent…

Contents