Matching to lists

[Razor303]

I'am trying to match two lists of names, but having a problem with
apostrophe's.
here is a link to download wookbook and a screen clip and help much appreciated.
https://cid-079d03a4b4decc0e.office.live.com/view.aspx/Horse racing/match two lists ^52^6.xlsx

 

[Razor303]

Crook101, said to use Control H to remove the apostrophe. I could put that into a macro, also adding other stuff I do'nt need in the list like (IRE) Or (USA) at the end of the name, clearing it all up before i match the list's.

this =ISNUMBER(MATCH(SUBSTITUTE(E11,"'",""),$C$10:$C$27,0)) does work fine by the way and I will be using it. CHEERS GDH for that...

 

[Razor303]

Hi

Are you simply trying to ascertain whether the item in the 4th column does appear in the 1st column or should it agree on a line-by-line basis?

May I just ask, what is the purpose of the last 2 columns? They appear to be repeats of eachother?

The Right hand Colum next to the true and false is my critera, the next row witch is the same as the critera is the list is wish to match to the left hand colum of names that is in caps. I set it up this way to use the formular =AND(ISNUMBER(MATCH(D152,B152:C152,1))).
There are less names in the left hand colum ( the one in caps), so thay no not match, I need a list With the apostrophes in lower case and the letters A,B,C Etc. in the far left colum that is asigned to that name.

<TABLE style="WIDTH: 148pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=197><COLGROUP><COL style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3803" width=104><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 78pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 width=104>B

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=93>Carrie's Magic</TD></TR></TBODY></TABLE>

 

[Razor303]

Thanks GDH, Iam using this =ISNUMBER(MATCH(SUBSTITUTE(F2,"'",""),B2,0)) and Its working fine, now i am on with the rest of my project.