G
ganga
I have 2 schedules (2 different work books). One is monthly vacation schedule
and other one is weekly working schedule. I need a formula in weekly schedule
if I enter the name in the vacation schedule I want to look for a name and
date in the weekly schedule and say off for that day for that name.
Eg,if I enter Mat on nov 23 rd in vacation schedule, in the weekly schedule
I want to say off (B2) beside mat name(A2) on nov 23rd (B1). In vacation
schedule mat name can be anywehre within that day for example if the date is
on A1 then mat can be in A2 or A4 or anywhere in column A.
and other one is weekly working schedule. I need a formula in weekly schedule
if I enter the name in the vacation schedule I want to look for a name and
date in the weekly schedule and say off for that day for that name.
Eg,if I enter Mat on nov 23 rd in vacation schedule, in the weekly schedule
I want to say off (B2) beside mat name(A2) on nov 23rd (B1). In vacation
schedule mat name can be anywehre within that day for example if the date is
on A1 then mat can be in A2 or A4 or anywhere in column A.