D
Dave Potter
I'm really struggling with getting this formula to do what I want. Any
help would again be appreciated. Some have helped get me to where I
am. I just keep running into more conditions I have to meet.
Here is the formula (which works fine except for one condition) and
then I'll explain what else I need it to do.
=IF((VLOOKUP($A8,TUE!$A$11:$CB$29,1,FALSE)=0),"",IF((VLOOKUP($A8,TUE!$A$11:$CB$29,2,FALSE)=0),VLOOKUP($A8,TUE!$A$11:$CB$29,79,FALSE),VLOOKUP($A8,TUE!$A$11:$CB$29,2,FALSE)))
Sheet tabs are Mon, Tue, Wed, Thur, Fri, Sat, Sun.
The VLOOKUPs are looking for matching peoples names.
If I enter David in MON!$A11 and enter the Time in and Time out in B11
and C11, Then I enter David in CREW SCHEDULE!A8 , the values in
MON!B12 and MON!C11 should be returned in CREW SCHEDULE!B8 AND C8
The formula above is in CREW SCHEDULE!K8 AND L8.
A8 B8 C8 K8 L8
DAVID 7:00 AM 4:00 PM #N/A #N/A
Since A8 is no longer blank (David works on Monday) and there is no
matching name in TUE!$A$11:$CB$29 (David doesnt work on Tuesday), Im
getting the #N/A. If David worked Tuesday, the formula would work
fine. I need to get rid of the #N/A though because I need to sum up
the column. This is very complicated since there are so many
variables. The =0 part needs to stay there.
Thats the best I can explain it right now. If any one cares to tackle
this, I will be watching the group so I can provide further
clarifications if needed.
Thank you
David
help would again be appreciated. Some have helped get me to where I
am. I just keep running into more conditions I have to meet.
Here is the formula (which works fine except for one condition) and
then I'll explain what else I need it to do.
=IF((VLOOKUP($A8,TUE!$A$11:$CB$29,1,FALSE)=0),"",IF((VLOOKUP($A8,TUE!$A$11:$CB$29,2,FALSE)=0),VLOOKUP($A8,TUE!$A$11:$CB$29,79,FALSE),VLOOKUP($A8,TUE!$A$11:$CB$29,2,FALSE)))
Sheet tabs are Mon, Tue, Wed, Thur, Fri, Sat, Sun.
The VLOOKUPs are looking for matching peoples names.
If I enter David in MON!$A11 and enter the Time in and Time out in B11
and C11, Then I enter David in CREW SCHEDULE!A8 , the values in
MON!B12 and MON!C11 should be returned in CREW SCHEDULE!B8 AND C8
The formula above is in CREW SCHEDULE!K8 AND L8.
A8 B8 C8 K8 L8
DAVID 7:00 AM 4:00 PM #N/A #N/A
Since A8 is no longer blank (David works on Monday) and there is no
matching name in TUE!$A$11:$CB$29 (David doesnt work on Tuesday), Im
getting the #N/A. If David worked Tuesday, the formula would work
fine. I need to get rid of the #N/A though because I need to sum up
the column. This is very complicated since there are so many
variables. The =0 part needs to stay there.
Thats the best I can explain it right now. If any one cares to tackle
this, I will be watching the group so I can provide further
clarifications if needed.
Thank you
David