sample

Thank you, thank you,
if this works, I owe you tremondously.

thanks again,
cliff

Okay, I'll try to explain better. I have a schedule that I made in excel. It has a page for each day of the week. Now on a separate page in the same workbook, i will be creating a sort of database that will keep track of the number of hours scheduled each day for a weekly total. In this new page in cell C15 I need to write a formula that will search the Thursday page for one name only and if found will copy the number of hours scheduled to the cell. On the Thursday page lets say in cell A15 I have the name Roy, which is the name I am searching for. Now the number of hours scheduled will be in cell C15. Can Excel search for text then when found copy the information that is two columns to the right to a cell on another page.

Cliff
The following formula will search for "Roy" in Column A of the sheet called "Thursday" and display whatever is in Column C of the same row. You might find it useful to look at the VLOOKUP worksheet function in online help for an explanation of this formula.

=VLOOKUP("Roy",Thursday!A:C,3,FALSE)

If "Roy" appears more than once in Column A, the formula result will be for the first "Roy".
If "Roy" is not found, "#N/A" will be displayed. To display somethung other than "#N/A" (e.g. to display "Can't find Roy"), change the formula to :-

=IF(ISNA(VLOOKUP("Roy",Thursday!$A:$C,3,FALSE)),"Can't find Roy",VLOOKUP("Roy",Thursday!$A:$C,3,FALSE))

Post again if the above is not what you need.

There might be better ways of doing what you need. If you want to pursue alternatives, please post the exact lay-out of the daily sheets and the lay-out of the "summary" sheet with both of them containing some completed sample data that illustrates what you want.

Celia