I might get in trouble for this but if you're using Excel 2003 you are limited with your options so pop over to MrExcel and have a look at the Hall of Fame at Alan's UDFs for the Fuzzy Match.

Dom