On the Employees worksheet, delete column B. This will cause a #REF! error on the Schedule worksheet. Open the downloaded Excel_BU04_HotelEmployee.xisx workbook. On the HotelSchedule workbook, click the Schedule worksheet and modify the table array reference in the VLOOKUP formulas in cells B7:B26 to reference cells A6:B15 (named Employee) on the HotelEmployee workbook. Close the Excel_BU04_HotelEmployee.xisx workbook