Is it possible to shorten this LOOKUP Formula?

[Dale G]

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 Friday’s 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$83),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$22),"")


950-999 Monday’s 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),"")

 

[Bob Phillips]

Why not just use

=IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$22),LOOKUP(A3,Feeder!$A$2:$C$83))

 

[Don Guillett]

Modify this idea to suit
=VLOOKUP("apple",IF(K2="f",A1:B4,A2:B4),2,0)

 

[Dale G]

I had H set that way, but I when I entered Tuesday, Wednesday, or Thursday
the column would be blank.

 

[Bob Phillips]

Does that mean it works or that it doesn't?

 

[Dale G]

oops, sorry my mistake. I had,

=IF($A$1="Monday",LOOKUP(A7,Feeder!$A$2:$C$83),"")&IF($A$1="Friday",LOOKUP(A7,Feeder!$H$3:$I$22),"")
and that left the blanks, for Tuesday, Wednesday, Thursday.

Your right, Thank You. I'm glad you asked if it work.

900-936 Friday’s off;
=IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$22),LOOKUP(A3,Feeder!$A$2:$C$83))
950-986 Monday’s off;
=IF($A$1="Monday",LOOKUP(A3,Feeder!$H$24:$I$43),LOOKUP(A3,Feeder!$A$2:$C$83))