Perhaps copy the names to a helper column, then select the column and
replace (remove) all dots 'Corporation' 'corp' 'Incorporated' 'Inc' and
other un-required words from the front sheet and then again with hte
VLookUp area

This should provide a better match


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=385398