Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup/Hlookup confusion
Hi guys, need a bit of help working this one out
I've got 3 sheets currently sorting out schedules for staff. Sheet one lines up like Break 1 Taken Break 2 Taken Break 3 Taken Person 10:10:00 12:25:00 14:40:00 Person 1 10:10:00 12:25:00 14:40:00 Where it is blank under taken, i am trying to get a Look up to check A2 (Person) in Sheet C. Sheet C is where i issue is as it is ordered with duplicates Row 1+2 Person Person Person Person 5 Person 5 Person 5 11:43:20 14:00:05 16:24:34 12:04:16 14:24:46 16:08:52 All the names and times below them are ordered alphabetically so all correspond correctly. but i cannot figure out the Hlookup for finding the data for each taken break to see if they where taken within their schedule. as well as doing the same for all three breaks, while searching duplicate data. any help would be great |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup/Hlookup confusion
On Tuesday, March 13, 2012 6:45:07 AM UTC-5, Jumanjiman wrote:
Hi guys, need a bit of help working this one out I've got 3 sheets currently sorting out schedules for staff. Sheet one lines up like Break 1 Taken Break 2 Taken Break 3 Taken Person 10:10:00 12:25:00 14:40:00 Person 1 10:10:00 12:25:00 14:40:00 Where it is blank under taken, i am trying to get a Look up to check A2 (Person) in Sheet C. Sheet C is where i issue is as it is ordered with duplicates Row 1+2 Person Person Person Person 5 Person 5 Person 5 11:43:20 14:00:05 16:24:34 12:04:16 14:24:46 16:08:52 All the names and times below them are ordered alphabetically so all correspond correctly. but i cannot figure out the Hlookup for finding the data for each taken break to see if they where taken within their schedule. as well as doing the same for all three breaks, while searching duplicate data. any help would be great Send ME your file and a complete explanation dguillett1 @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and HLOOKUP | Excel Worksheet Functions | |||
VLOOKUP Looking In Different Workbook Confusion | Excel Worksheet Functions | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
Vlookup Count confusion ! | Excel Worksheet Functions | |||
VLOOKUP or HLOOKUP?? | Excel Worksheet Functions |