Vlookup/Hlookup confusion

C

Chris Jewitt

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
 
D

Don Guillett

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
 

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