PDA

View Full Version : Management weekly report



Svmaxcel
10-20-2017, 05:01 AM
In our company, every week some changes are done as per requirements like change of department, Manager..When I create report I have to specify that the emp was under which department/Manager on a particular week.I would like to know, how can I find the same using Index match.

offthelip
10-21-2017, 09:41 AM
You haven't given any indication of where "Manager" is specified. Is it provided in E5to BD10 of the ID sheet and you want to get it in the column E of "sheet2" or is it specified in column E of sheet 2 and you want to fill it in on the ID sheet?

Svmaxcel
10-22-2017, 12:44 AM
My bad, forgot to mention it.

ID sheet will have data for mapping.
Row which has week numbers will represent Manager name for the week
Sheet2 will check week number and according mention manager

offthelip
10-22-2017, 06:30 AM
try this:

=OFFSET(ID!$D$4,MATCH(D4,ID!$D$5:$D$9,0),MATCH(B4,ID!$E$4:$BD$4))