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.
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?
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