In this assignment, you will practice the most commonly-used lookup function, VLOOKUP.
Download the attached file MegaCorp-Sales-Data-VLookup-Assignment-CIS101. You may recognize these sales data from the previous week’s pivot exercise. However, in this file the Product names have been filled in by using the VLOOKUP function to retrieve the name from the Product List sheet, based on the ProductID.
Use VLOOKUP to retrieve each Salesperson’s name, Title and Commission rate from the Salesperson List, based on the SPID (Salesperson ID). Save the file with your name included in the filename and submit.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|