clueless where to start.

[qteekat]

I'm using 8 sheets in a workbook

Sheet 1 :

Col A= names of employess

col C-I = days of the week

I'm trying to find a function that will input the employee's name on sheet 2
when "4am" (is the time start) is typed under the day of the week they have
to work. Each day of the week will have it's own sheet. And i need it to put
the all the employe's name that has to work on that day to each separate
sheet that they work.

I hope that explains what I need. Thank you in advance.

 

[ryguy7272]

Depending on the arrangement of the data, Vlookup could work for you:
http://www.contextures.com/xlFunctions02.html

If that doesn't give the desired results, try Index/Match:
http://www.contextures.com/xlFunctions03.html


Also, check this out:

(very annoying voice, but you should learn a thing or two)

(not such an annoying voice...)

 

[T. Valko]

very annoying voice, but you should learn a thing or two

I hope that dude isn't a teacher!

 

[qteekat]

Okay. I learned a thing or two but still not working for me.

Sheet 1 looks like this


Monday Tuesday Wednesday Etc...

John Smith off 4am 4am
Katie Jones 4am 4am 4am
Dawn Moran 4am 4am off

etc....


I would like sheet 2 (renamed "Monday") to list the names with "4am" under
the column Monday. And not list the names with "off" under the Monday column.


So "Monday" sheet should look someting like

Schedule

Katie Jones
Dawn Moran
etc...