• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Excel in Practice

The VLOOKUP function combined with a list of employees can look up the rates of the employees. Take this example one step further as shown in Figure 13.16 and create a PivotTable that summarizes the list of employees’ hours and dollars from the list. You can make an extended range for the source data of the table so that when you add to the list, the PivotTable automatically includes the new list data in the summary PivotTable.

To create an automatic summary like the one in Figure 13.16, set up your Rate Table first. Then, create your list with the VLOOKUP function referencing the table. Then, select the range of the list, or select an extended range the list will never grow to, such as E7:H40,000. From that list, create a PivotTable summarizing the total values for each employee.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint