Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, then formula to capture data?
Hope I'm in the right forum...
What I'd ultimately try to do is to have a link between sheets but with different data being propagated. Such as: Sheet "A" is the schedule sheet with employee names listed. Let's say Employee "1" is listed in cell A1 and I input 9:30 AM in cell B1 (i.e., Employee "1" scheduled for 9:30). Sheet "B" is a list of the schedule times. If 9:30AM is in cell A4, is there a way to automatically propagate "Employee 1" into B4 when "9:30 AM" is input to B1 on Sheet "A"? I suppose the formula I'm looking for is something like: =if(sheet1!B1="Employee 1")="Employee 1" Thanks (I think I'm moving into "Access" here) -- 6-West -- 6-West |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, then formula to capture data?
Try this: enter in B1 on Sheet2 and copy down. It assumes a 1:1 relationship
between an employee and a time. If multiple employees can have the same time, then it will not work. =IF(ISNA(MATCH(A1,Sheet1!B:B,0)),"",INDEX(Sheet1!$ A$1:$A$1000,MATCH(A1,Sheet1!B:B,0))) HTH "sixwest" wrote: Hope I'm in the right forum... What I'd ultimately try to do is to have a link between sheets but with different data being propagated. Such as: Sheet "A" is the schedule sheet with employee names listed. Let's say Employee "1" is listed in cell A1 and I input 9:30 AM in cell B1 (i.e., Employee "1" scheduled for 9:30). Sheet "B" is a list of the schedule times. If 9:30AM is in cell A4, is there a way to automatically propagate "Employee 1" into B4 when "9:30 AM" is input to B1 on Sheet "A"? I suppose the formula I'm looking for is something like: =if(sheet1!B1="Employee 1")="Employee 1" Thanks (I think I'm moving into "Access" here) -- 6-West -- 6-West |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, then formula to capture data?
Thanks, the formula worked fine when I pasted it into a test sheet, but when
I tried it in my project and changed the cell references to match up, I started to get errors. Any idea where I might be going wrong? Thanks again -- 6-West "Toppers" wrote: Try this: enter in B1 on Sheet2 and copy down. It assumes a 1:1 relationship between an employee and a time. If multiple employees can have the same time, then it will not work. =IF(ISNA(MATCH(A1,Sheet1!B:B,0)),"",INDEX(Sheet1!$ A$1:$A$1000,MATCH(A1,Sheet1!B:B,0))) HTH "sixwest" wrote: Hope I'm in the right forum... What I'd ultimately try to do is to have a link between sheets but with different data being propagated. Such as: Sheet "A" is the schedule sheet with employee names listed. Let's say Employee "1" is listed in cell A1 and I input 9:30 AM in cell B1 (i.e., Employee "1" scheduled for 9:30). Sheet "B" is a list of the schedule times. If 9:30AM is in cell A4, is there a way to automatically propagate "Employee 1" into B4 when "9:30 AM" is input to B1 on Sheet "A"? I suppose the formula I'm looking for is something like: =if(sheet1!B1="Employee 1")="Employee 1" Thanks (I think I'm moving into "Access" here) -- 6-West -- 6-West |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting all rows of data that have a value in a particular column | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula to capture data on a date and preserve it | Excel Worksheet Functions |