Lookup, vlookup, find, or what

[JR Hester]

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

 

[Luke M]

You can't do that type of 3D referencing. Need to individually look through
each sheet
=ISNUMBER(MATCH(C2,'Friday 930am'!C2:C25))+
ISNUMBER(MATCH(C2,'Friday 12:30pm'!C2:C25))+
ISNUMBER(MATCH('Monday 1130am'!C2:C25))

Anything greater than 0 indicates a match was found.

 

[pmartglass]

one way

=COUNTIF('friday 930am'!C2:C25,A3)+COUNTIF('friday
1230pm'!C2:C25,A3)+COUNTIF('monday 1130am'!C2:C25,A3)

a3 being what you are looking for

it will count how many times it is on each page