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

Why not just use

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
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$8 3),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$2 2),"")


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

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


"Bob Phillips" wrote:

Why not just use

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
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$8 3),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$2 2),"")


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

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
I had H set that way, but I when I entered Tuesday, Wednesday, or Thursday
the column would be blank.


"Bob Phillips" wrote:

Why not just use

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
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$8 3),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$2 2),"")


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

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 Fridays off;
=IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$22),LOO KUP(A3,Feeder!$A$2:$C$83))
950-986 Mondays off;
=IF($A$1="Monday",LOOKUP(A3,Feeder!$H$24:$I$43),LO OKUP(A3,Feeder!$A$2:$C$83))


"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
I had H set that way, but I when I entered Tuesday, Wednesday, or Thursday
the column would be blank.


"Bob Phillips" wrote:

Why not just use

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
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$8 3),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$2 2),"")


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

Well I am no wiser as to whether it works or not. I was proposing just the
one formula for all circumstances, Mon, Tue, Wed,... off, namely

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


--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
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),LOO KUP(A3,Feeder!$A$2:$C$83))
950-986 Monday's off;
=IF($A$1="Monday",LOOKUP(A3,Feeder!$H$24:$I$43),LO OKUP(A3,Feeder!$A$2:$C$83))


"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
I had H set that way, but I when I entered Tuesday, Wednesday, or
Thursday
the column would be blank.


"Bob Phillips" wrote:

Why not just use

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

--
__________________________________
HTH

Bob

"Dale G" wrote in message
...
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$8 3),"")&IF($A$1="Friday",LOOKUP(A3,Feeder!$H$3:$I$2 2),"")


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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dale G" wrote in message
...
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),"")