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.

Thank you in advance
 
E

Excel Guru of note!

In your example, I would suggest you use an index and match formula. You
would combine this with an if(iserror()) calc. I assume your shift time comes
from another sheet, if this is the case do the index and match on this too.
Thus, if one condition, validate, else, get shift time.
 
G

ganga

Thanks for the help but i'm not really familiar with those functions. can you
please tell me the formula for this.
 
D

Don Guillett

Perhaps you could try the HELP index and look for MATCH and then look for
INDEX
 
G

ganga

I tried that too but that gives you for simple examples not for complicated
like this.
 
D

Don Guillett

Use the match one first and then try the index with dummy data and then
incorporate your match in the index function. It will mean more if you do
it.
 

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

Please help me -urgent 1
match 3
look up 0
vacation 1
lookup 0
Countifs or a pivot 1
Adding rota 0
Template help please 1

Top