Hi,

I have 2 work books. One is weekly schedule and other one is yearly vacation
schedule. I would like to link both books matching names and dates. Vacation
schedule is in monthly format and weekly schedule is in weekly format.

Eg: yearly vacation schdule
jan 1 Jan 2 Jan 3 and so on
ram siva
ganga

weekly schedule
jan 1 Jan 2 Jan 3
ram off 10-6 9-5
ganga off 9-5 11-7
siva 10-6 off 9-5


I need a formula in weekly schedule saying that if the date and name match
in yearly schdule says €œoff€� otherwise shift time under the same date and
name.

Thank you in advance.