Menu
In this lesson, we use the “VLOOKUP()” function in Excel to add even further information to our data set from Lookup Tables.
This is extremely useful when we want reports to show data with names of the Month or of Weekdays, and when we want the data split into specific segments of our own choosing.
We used formulas in Pivots 02 to extract information related to Year, Month, Week, Weekday and Hour.
But Month was a number, and so was Weekday. If we want reports to show “January, February, etc” for the Months, and “Monday, Tuesday, etc” for the Days, then we we need to make some small tables where we indicate what label we want in text for each of these numbers.
For this, we create a Tab in our spreadsheet (which is called “Lookups” in our sample, but you can name the tab as you wish). On that tab, we create our own small tables and then we use the Excel function “VLOOKUP” in our data list to find the appropriate label for each Month Number and Weekday Number.
We also split the 24 hours of each date into 4 hour-ranges and define Day and Night.
These time-related data are then added to our Weather data.
