| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help me-urgent
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
please help me-urgent
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. "ganga" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
please help me-urgent
Thanks for the help but i'm not really familiar with those functions. can you
please tell me the formula for this. "Excel Guru of note!" wrote: 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. "ganga" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
please help me-urgent
I tried that too but that gives you for simple examples not for complicated
like this. "Don Guillett" wrote: Perhaps you could try the HELP index and look for MATCH and then look for INDEX -- Don Guillett Microsoft MVP Excel SalesAid Software "ganga" wrote in message ... Thanks for the help but i'm not really familiar with those functions. can you please tell me the formula for this. "Excel Guru of note!" wrote: 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. "ganga" wrote: 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 . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
please help me-urgent
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "ganga" wrote in message ... I tried that too but that gives you for simple examples not for complicated like this. "Don Guillett" wrote: Perhaps you could try the HELP index and look for MATCH and then look for INDEX -- Don Guillett Microsoft MVP Excel SalesAid Software "ganga" wrote in message ... Thanks for the help but i'm not really familiar with those functions. can you please tell me the formula for this. "Excel Guru of note!" wrote: 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. "ganga" wrote: 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent | Excel Discussion (Misc queries) | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| #ARG! - urgent | Excel Discussion (Misc queries) | |||
| Urgent Help | Excel Discussion (Misc queries) | |||
| Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Linear Mode
