I have 3 groups of Drivers, all of them work a for day work week. Group 1
works Monday-Thursday, 2 works Tuesday-Friday, and 3 works Friday, Saturday,
Sunday, Monday. Group 1 with Friday off has assignment numbers of 900-949, 2
with Monday off has 950-999, 3 does 900-949 on Friday and 950-999 on Monday.
(The weekend numbers are totally different and not included in this process).
On my spread sheet I use these numbers in column A to time track the drivers
as they pass various locations. Column H is where I place the names of the
drivers. I have H set to change names for the different days of the week.
I'm wondering if I can shorten this formula, by using an abbreviation.
Weekday, Mon-Thur, something like that?


900-949 Fridays off;

=IF($A$1="Monday",LOOKUP(A3,Feeder!$A$2:$C$83),"") &IF($A$1="Tuesday",LOOKUP(A3,Feeder!$A$2:$C$83),"" )&IF($A$1="Wednesday",LOOKUP(A3,Feeder!$A$2:$C$83) ,"")&IF($A$1="Thursday",LOOKUP(A3,Feeder!$A$2:$C$8 3),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$2 2),"")


950-999 Mondays off;


=IF($A$1="Monday",LOOKUP(A41,Feeder!$H$24:$I$43)," ")&IF($A$1="Tuesday",LOOKUP(A41,Feeder!$A$2:$C$83) ,"")&IF($A$1="Wednesday",LOOKUP(A41,Feeder!$A$2:$C $83),"")&IF($A$1="Thursday",LOOKUP(A41,Feeder!$A$2 :$C$83),"")&IF($A$1="Friday",LOOKUP(A41,Feeder!$A$ 2:$C$83),"")