Lookup, vlookup, find, or what

J

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
 
L

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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top