Return column values based on criteria (HLOOKUP & VLOOKUP?)

S

SalientAnimal

Hi All,

I have been creating a schedule on excel, the schedule includes a to
row which has the following headings
Date, Agent_ID, title, agent_name, 07:00, 07:15, 07:30, etc up unti
21:45

The columns that are named with times are times that indicate a brea
time.
The column named title is the actual shift time, eg 08:00 - 17:00.

I need a formula that would look at my source data, and populate a shee
in the following layout

agent_id, agent_name, title, start_time, end_time

The title be one of the following:
Shift 08:00 - 17:00
Tea Break 10:00 - 10:15
Lunch Break 12:00 - 12:30
Tea Break 14:15 - 14:30

Can someone help me with how I would achieve this. If I need to have th
shift portion and the break portion appear on separate tabs that woul
also be ok, but ultimately I need to keep my original source as is, bu
the change it to be able to upload it into a MySQL database.

Sample sheet attahed

+-------------------------------------------------------------------
|Filename: sample_schedule.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=943
+-------------------------------------------------------------------
 

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

Similar Threads

Pls help for Simple Calculation 1
Macro for Copying pasting between different spreadsheets 4
Schedule and Timesheet 4
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
Query/Expression Help Required! 2
Query/Expression Help Required! 3
excel timesheet and drop down boxes 3
Scheduling/Logic Error 3

Top