So, let's jump over to Excel and give this a shot. So, essentially what we're doing in column C here is we're looking up the Month of each given Date, finding it in our Lookup data and returning the appropriate Season. So, as you can see, Month is our common field or key that's going to allow us to pull Season into our Source data file. And we've got Lookup data on the right which includes data for Month and Season. We've got Source data on the left which includes a column Date and a column for Month. So, taking a look at a simple example here. So, both of sources need to contain one common field and that's what allows you to merge the two sources together. One thing to keep in mind when you're using a function like VLOOKUP is that it requires a unique, common field or a key that is shared between your source data and your lookup data. And basically, it just allows you to join data from separate sources using a common lookup value. VLOOKUP is one of the most popular lookup reference functions in Excel. All right, next up, we're going to be creating a new field to categorize season and we're going to categorize season using a function called VLOOKUP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |