Match help again easier this time

[Mrbanner]

OK
Same data put it into 1 sheet
a b
1 hi.htm hi.htm
2 hello.htm hellow.htm
3 blue.htm bbloe.htm
4 bbloe blue.htm
5 happy.htm jeusus.htm
6 happy1.htm



Ok A has 1905 lines b has 2010 lines
what i need to do is if Anywhere in b1:1905 matches anywhere in
a1:2010
In C1:2010 it shows True or false.
that way i can see what records are missign from the colum B
and then fix them up quickly

That make more sense?...

 

[carlo]

OK
Same data put it into 1 sheet
a b
1 hi.htm hi.htm
2 hello.htm hellow.htm
3 blue.htm bbloe.htm
4 bbloe blue.htm
5 happy.htm jeusus.htm
6 happy1.htm

Ok A has 1905 lines b has 2010 lines
what i need to do is if Anywhere in b1:1905 matches anywhere in
a1:2010
In C1:2010 it shows True or false.
that way i can see what records are missign from the colum B
and then fix them up quickly

That make more sense?...

Did you read my reply on your old thread? You could have told
me if it didn't work, or at least answer my question.
Try to reply on the same thread instead of opening a new one.
Other people can try and give you new solutions when they
see what the problem was in your old conversations.

old thread
http://groups.google.com/group/micr...615376f0f6a/9935f46c1b72dd83#9935f46c1b72dd83

 

[Bob Phillips]

=ISNUMBER(MATCH(A1,B:B,0))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)