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" 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 mindNext: series of sums in a long spreadsheet