Matching horse names/saddle cloths.

[easternpromise]

Hello all,

Can someone advise how i can monitor the prices of a horse on both befair and betdaq in excel.

I have tried using a vlookup but sometimes the names of the horse are spelt slightly different.

I tried to use saddle cloth number but i don't think betdaq has this excel export feature.

Could someone advise.

Many Thanks

[Shaun]

I don't think the names would be spelled different just displayed different, do you have an example of the the horse with different names.

[KevinTHFC]

I would guess that it is down to the apostrophe that the sites use in names that have them. Some sites use a ' and others a `.

If thats the case you could standardise all names by doing a search and replace to ensure both sites are using the saem apostrophe

[Shaun]

That's what i was thinking may be the issue, i don't use betdaq so can't confirm this.