Search for question
Question

a) Merge the Sales and Employees data on sheets 5 and 6 by using appropriate Lookup, Match and/or Index functions in Excel (do not use VBA) to bring in all

the employee details (columns B – F)into the sales spreadsheet. b) Using the same Excel functions, check the Sales spreadsheet for any employees that are listed here, and which are not in the Employees data. Then do the same to find employees present in the Employees sheet but not in the Sales sheet. List the additional/missing employee numbers in a newcolumn.

Fig: 1

Fig: 2