I need help matching text from one spreadsheet to another.

Hi,

I hope someone can help me. I have 2 different spreadsheets, one is called "schedule" the other is called "roster", I want to search for the text "shift A" in C9:C22 on the "schedule" spreadsheet, if it finds the text "shift A" I need it to take the "employees name" in that row in the column A9:A22 and place it into cell C3 in the spreadsheet "Roster".

I hope this makes sense, I'm new to excel and have tried all day to figure this out with no luck. Any help would be greatly appreicated.

Thanks,
Scott