Is it possible to shorten this LOOKUP Formula?

D

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),"")
 
B

Bob Phillips

Why not just use

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

Dale G

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

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top