Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow for multiple values in VLOOKUP?
I have a list of people that are working particular shifts which are set up
in four to five hour increments. Some people are working consecutive shifts (working eight/nine hours in a day). I am trying to show each person's schedule with beginning and end times using VLOOKUP. It is working just fine if the people only work one shift per day. The multiple shift people only have their first shifts display. I would like to LOOKUP based upon the person's name giving the first shift's start time and the second shift's end time and haven't found a good combination of functions to use. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow for multiple values in VLOOKUP?
Hi!
Do the shifts span past midnight like 10:00 PM - 6:00 AM ? If not then you could use something like this: For the earliest start time: =MIN(IF(A1:A10="some_name",B1:B10)) For the latest end time: =MAX(IF(A1:A10="some_name",B1:B10)) You can replace "some_name" with a cell reference. These are array formulas and must be entered using the key combination of CTRL,SHIFT,ENTER. Biff "Indy_Ball" wrote in message ... I have a list of people that are working particular shifts which are set up in four to five hour increments. Some people are working consecutive shifts (working eight/nine hours in a day). I am trying to show each person's schedule with beginning and end times using VLOOKUP. It is working just fine if the people only work one shift per day. The multiple shift people only have their first shifts display. I would like to LOOKUP based upon the person's name giving the first shift's start time and the second shift's end time and haven't found a good combination of functions to use. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow for multiple values in VLOOKUP?
Biff -
That worked marvelously. Thanks "Biff" wrote: Hi! Do the shifts span past midnight like 10:00 PM - 6:00 AM ? If not then you could use something like this: For the earliest start time: =MIN(IF(A1:A10="some_name",B1:B10)) For the latest end time: =MAX(IF(A1:A10="some_name",B1:B10)) You can replace "some_name" with a cell reference. These are array formulas and must be entered using the key combination of CTRL,SHIFT,ENTER. Biff "Indy_Ball" wrote in message ... I have a list of people that are working particular shifts which are set up in four to five hour increments. Some people are working consecutive shifts (working eight/nine hours in a day). I am trying to show each person's schedule with beginning and end times using VLOOKUP. It is working just fine if the people only work one shift per day. The multiple shift people only have their first shifts display. I would like to LOOKUP based upon the person's name giving the first shift's start time and the second shift's end time and haven't found a good combination of functions to use. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I allow for multiple values in VLOOKUP?
You're welcome. Thanks for the feedback!
Biff "Indy_Ball" wrote in message ... Biff - That worked marvelously. Thanks "Biff" wrote: Hi! Do the shifts span past midnight like 10:00 PM - 6:00 AM ? If not then you could use something like this: For the earliest start time: =MIN(IF(A1:A10="some_name",B1:B10)) For the latest end time: =MAX(IF(A1:A10="some_name",B1:B10)) You can replace "some_name" with a cell reference. These are array formulas and must be entered using the key combination of CTRL,SHIFT,ENTER. Biff "Indy_Ball" wrote in message ... I have a list of people that are working particular shifts which are set up in four to five hour increments. Some people are working consecutive shifts (working eight/nine hours in a day). I am trying to show each person's schedule with beginning and end times using VLOOKUP. It is working just fine if the people only work one shift per day. The multiple shift people only have their first shifts display. I would like to LOOKUP based upon the person's name giving the first shift's start time and the second shift's end time and haven't found a good combination of functions to use. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use vlookup or other to find the nearest values (<) or interpola | Excel Worksheet Functions | |||
Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
vlookup returning multiple values | Excel Worksheet Functions | |||
VLOOKUP FOR MULTIPLE VALUES | Setting up and Configuration of Excel | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |