more conditions than I know what to do with

  • Thread starter Thread starter erica
  • Start date Start date
E

erica

Hello everyone!
I need some help with a formula for a project I have
going. I have a list of clients (withappt date and time,
controller, adresses, phone #'s etc., all in seperate
cells), sorted by date and time, then by controller. I
also have a workbook of 3 months of daily 4 part schedules
(15 min increments,looks like an appt book). I cannot
find a formula that will give me the result I need. I
need the formula to reference only the client name in the
time slot that matches the appt specified in the list, and
also to pull and place the client in the correct appt time
spot under the correct controller.

Whew! I have tried conditional, vlookup and dget
formatting and am running out of ideas and time.

Oh- did I mention I would like to be able to copy the
formula instead of recreating it in 20,000 cells?

Somebody please help me!!

Thanks-
Erica
 
This works better

Assuming that you have

Date in Column A
Start Time in Column B
Controller in Column C

and no overlapping time slots,

Then

=A2&B2&C2 would create a unique index value for each appointment

Your output would be

Controllers across top row
Date & Start Time in left columns


The Formula is

=OFFSET("Top Cell of Client Name
Range",MATCH(&Datecell&timecell&controllercell,"index column range",0),0)

PC
 
Back
Top