Prev: Formula showing in cell -- Never mind
Next: series of sums in a long spreadsheet
From: JR Hester on 1 Apr 2010 15:51
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
From: Luke M on 1 Apr 2010 15:57
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.



--
Best Regards,

Luke M
"JR Hester" <JRHester(a)discussions.microsoft.com> wrote in message
news:09657A93-3C42-4D6D-A06B-EDF6C5CC4C83(a)microsoft.com...
> 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


From: pmartglass on 1 Apr 2010 16:36
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


"JR Hester" wrote:

> 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
 | 
Pages: 1
Prev: Formula showing in cell -- Never mind
Next: series of sums in a long spreadsheet