Thanks in advance. Xcel07 on WinXP.

I have a list of names in sheet 4, I need to search sheet 1, 2 and 3 to see
if each name on sheet4 is located on any of the other 3 sheets. Here are a
couple of my attempts so far
=LOOKUP(C3,'Friday 930am:Monday 1130am'!C2:C25)
=SUMPRODUCT(C2*'Friday 930am:Monday 1130am'!C2:C25)

To clarify the above
Sheet 1 is named Friday 930am
Sheet 2 is anmed Friday 12:30pm
Sheet 3 is named Monday 1130am


Any suggestions are welcome