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
From the course: Excel 2016: Advanced Formulas and Functions
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Looking up information with VLOOKUP and HLOOKUP4m 30s
-
Finding approximate matches with VLOOKUP and HLOOKUP7m 16s
-
Finding exact matches with VLOOKUP5m 30s
-
Nesting lookup functions4m 12s
-
Using VLOOKUP with large tables4m 21s
-
Finding table-like information within a function using the CHOOSE function2m 44s
-
Using the SWITCH function for formula-embedded selection5m 40s
-
Locating data with the MATCH function3m 43s
-
Retrieving information by location2m 53s
-
Using MATCH and INDEX functions together4m 14s
-
-
-
-
-
-
-
-
-
-