Please help me -urgent

G

ganga

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

Don Guillett

Using a meaningful subject line withOUT "urgent" (All treated as urgent
here) would help. Also, it would help if you fully explained your layout and
your question.Please try again if you expect meaningful assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match 3
please help me-urgent 5
look up 0
vacation 1
lookup 0
Yearly sum 3
Countifs or a pivot 1
Sum cells using criteria from a row and a column 2

Top