Still having trouble with this one. I used the formula above
(IF(AND(ISNA(MATCH(B3,F:F,0)),ISNA(MATCH(B3,G:G,0) )),"No","Matched")
but I get "No" for everything. I know that there should be matches.
For example this first list is what is in column B:

9997291093
9997291107

9997291123
9997291131
9997291158

9997291190
9997291204

9997291239
9997291255
9997291263
9997291271
9997291298
9997291301

I know that these items are in columns F or G, but I still get "No"

9997291131 9997291131
999729114X 999729114X
9997291158 9997291158
9997291166 9997291166
9997291174 9997291174
9997291182 9997291182
9997291190 9997291190
9997291204 9997291204
9997291212 9997291212
9997291220 9997291220
9997291239 9997291239
9997291255 9997291255
9997291263 9997291263
9997291271 9997291271
999729128X 999729128X
9997291298 9997291298
9997291301 9997291301
9997291603 9997291603
999729162X 999729162X
9997291638 9997291638
9997291646 9997291646
9997291654 9997291654
9997291662 9997291662
9997291670 9997291670
9997291891 9997291891
9997291913 9997291913
9997291921 9997291921
999729193X 999729193X
9997293975 9997293975
9997293983 9997293983
9997293984 9997293984
9997293991 9997293991

Can you help me think of another way to match these columns?

Thanks!

see response to your earlier posting

--
Regards

Roger Govier


"jack" wrote in message
oups.com...
Still having trouble with this one. I used the formula above
(IF(AND(ISNA(MATCH(B3,F:F,0)),ISNA(MATCH(B3,G:G,0) )),"No","Matched")
but I get "No" for everything. I know that there should be matches.
For example this first list is what is in column B:

9997291093
9997291107

9997291123
9997291131
9997291158

9997291190
9997291204

9997291239
9997291255
9997291263
9997291271
9997291298
9997291301

I know that these items are in columns F or G, but I still get "No"

9997291131 9997291131
999729114X 999729114X
9997291158 9997291158
9997291166 9997291166
9997291174 9997291174
9997291182 9997291182
9997291190 9997291190
9997291204 9997291204
9997291212 9997291212
9997291220 9997291220
9997291239 9997291239
9997291255 9997291255
9997291263 9997291263
9997291271 9997291271
999729128X 999729128X
9997291298 9997291298
9997291301 9997291301
9997291603 9997291603
999729162X 999729162X
9997291638 9997291638
9997291646 9997291646
9997291654 9997291654
9997291662 9997291662
9997291670 9997291670
9997291891 9997291891
9997291913 9997291913
9997291921 9997291921
999729193X 999729193X
9997293975 9997293975
9997293983 9997293983
9997293984 9997293984
9997293991 9997293991

Can you help me think of another way to match these columns?

Thanks!

Jack,
I did a Copy/Paste then "Text to Columns" of your data. When I
first tried the formula I got all "No"s but when I reeentered the column B
data (or copied it from Column F) where I knew there was a mactch, I got the
correct matches.

This suggests that there be leading/trailing blanks in your data (allowing
what happens when you (me!) copy form a web site) so it be worth checking
along these lines.

HTH

"jack" wrote:

Still having trouble with this one. I used the formula above
(IF(AND(ISNA(MATCH(B3,F:F,0)),ISNA(MATCH(B3,G:G,0) )),"No","Matched")
but I get "No" for everything. I know that there should be matches.
For example this first list is what is in column B:

9997291093
9997291107

9997291123
9997291131
9997291158

9997291190
9997291204

9997291239
9997291255
9997291263
9997291271
9997291298
9997291301

I know that these items are in columns F or G, but I still get "No"

9997291131 9997291131
999729114X 999729114X
9997291158 9997291158
9997291166 9997291166
9997291174 9997291174
9997291182 9997291182
9997291190 9997291190
9997291204 9997291204
9997291212 9997291212
9997291220 9997291220
9997291239 9997291239
9997291255 9997291255
9997291263 9997291263
9997291271 9997291271
999729128X 999729128X
9997291298 9997291298
9997291301 9997291301
9997291603 9997291603
999729162X 999729162X
9997291638 9997291638
9997291646 9997291646
9997291654 9997291654
9997291662 9997291662
9997291670 9997291670
9997291891 9997291891
9997291913 9997291913
9997291921 9997291921
999729193X 999729193X
9997293975 9997293975
9997293983 9997293983
9997293984 9997293984
9997293991 9997293991

Can you help me think of another way to match these columns?

Thanks!

Just a thought, but is it possible that the values you are trying to find are
formatted numeric and the lists you are looking in are text (or vice versa)?
If so, you can convert the numbers seen as text by placing a 1 in an unused
cell (formatted as a number) and use the copy and paste special/multiply.
Will

"jack" wrote:

Still having trouble with this one. I used the formula above
(IF(AND(ISNA(MATCH(B3,F:F,0)),ISNA(MATCH(B3,G:G,0) )),"No","Matched")
but I get "No" for everything. I know that there should be matches.
For example this first list is what is in column B:

9997291093
9997291107

9997291123
9997291131
9997291158

9997291190
9997291204

9997291239
9997291255
9997291263
9997291271
9997291298
9997291301

I know that these items are in columns F or G, but I still get "No"

9997291131 9997291131
999729114X 999729114X
9997291158 9997291158
9997291166 9997291166
9997291174 9997291174
9997291182 9997291182
9997291190 9997291190
9997291204 9997291204
9997291212 9997291212
9997291220 9997291220
9997291239 9997291239
9997291255 9997291255
9997291263 9997291263
9997291271 9997291271
999729128X 999729128X
9997291298 9997291298
9997291301 9997291301
9997291603 9997291603
999729162X 999729162X
9997291638 9997291638
9997291646 9997291646
9997291654 9997291654
9997291662 9997291662
9997291670 9997291670
9997291891 9997291891
9997291913 9997291913
9997291921 9997291921
999729193X 999729193X
9997293975 9997293975
9997293983 9997293983
9997293984 9997293984
9997293991 9997293991

Can you help me think of another way to match these columns?

Thanks!