Assume that you are provided with a data set containing employee details of a company. The columns include details like employee number, first name, last name, appraisal rating, location etc. You need to create a system where a person can enter any employee number and generate any one of 'First Name', 'Last Name', 'Date of Joining', 'Department', 'Designation', 'Appraisal Rating' or 'Location' as per the requirement of the person.
The system should prevent people from entering any random employee number and also any other field from what is mentioned above.
Note- You cannot use VLOOKUP or HLOOKUP
Bookmarks