|
Matching Items from 1 list to 2 others
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! |
Matching Items from 1 list to 2 others
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! |
Matching Items from 1 list to 2 others
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! |
Matching Items from 1 list to 2 others
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! |
| All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com