I have a worksheet which consists employees attendance for a week. The attendance will be available from a web based App and employees can be log in at site, which will tagged with their geofence (location). The output of the App will be available in xls format. Refer for the sheet 2 (WeekilyAttendance) of my xls file attached.
Now, i need to carryout a multiple lookup for both date and employee code, and fill the Work_Location in the sheet 1 (DailyReport) against each date/for each employee. Is there any shirt cut formula, without modifying the format??
Now, i need to carryout a multiple lookup for both date and employee code, and fill the Work_Location in the sheet 1 (DailyReport) against each date/for each employee. Is there any shirt cut formula, without modifying the format??