Join Dennis Taylor for an in-depth discussion in this video Solution: Match data across different lists using VLOOKUP, part of The 5-Day Excel Challenge.
- Our first objective in day five of the five-day…Excel challenge is to use the Vlookup function in column G…to return the salary for each person whose name…we see here in column E.…And, imagine if we were doing this from a different…worksheet, although in the example here…for ease of readability the data that we're looking…at is in columns A and B.…So, in this list over here, although we might not…be seeing that name, Max Mendez,…his name is there, his salary is to the right.…The Vlookup function, one of it's major uses is to…match up information when we have an exact match.…
Sometimes, you can use Vlookup for what's called…an approximate match when we're dealing…strictly with numbers.…=Vlookup is the function.…It begins with the data we're trying to look up,…it's in cell E2, Max Mendez is the name here, comma.…We're trying to match up information from column A.…And, when we do find the match we wanna pull data…out of column B.…So, we next refer to what's called the table array.…We can do this for the entire column.…
The challenges will ask you to:
- Generate a list of future dates
- Clean up a list of employee data
- Create a dynamic chart
- Create a pivot table to analyze sales data
- Match data across multiple lists
Starter and solution files for Excel 2010, 2013, 365, and Excel for Mac 2011 are provided in the exercise files, so you can follow along with your version of Excel.