I am looking to identify text cells that are not identical but are similar. I have two spread sheets with slightly different customer names and I want to compared/match them.
An example might be:
Blue Chip
Bluechip
or
Softcell Limited
Soft Cell Ltd
I have tried VLOOKUP but it either has to be an exact match OR if finds approximate match (which comes up with some interesting results!)
thanks
Last edited by mintribe; 12-20-2011 at 02:38 PM. Reason: issue solved
Hi,
This may be worth a look:
http://www.microsoft.com/bi/en-us/Co...nforExcel.aspx
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Fantastic thanks Fuzzy Lookup worked a treat and saved me a load of time
SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks