I am trying to make a schedule for work. The schedule consisits of two columns for each day, one for am and pm. I need to transfer this data to a sheet we call the dailies.

Can anyone tell me for example how to:

In cell B3 in sheet 2, search column C in sheet 1 for the number "1". When it finds #1, I need the name of person listed in Column A of the row #1 was found in to appear in B3 sheet 2.

I hope this is clear.