aHHH, so both formulas (VLOOKUP and MATCH) are case sensitive? I tried
the MATCH formula and it returned only "CUSTOMER" as the result. My
column of All Names is in Caps where as my column of distys are Title
Case.

I do realize I will get some error whenever a dash or something else is
added on to one name and not the other - wish I could get it to accept
wildcards, but then we're talking writing a program and at this point,
it's fast to do this manually!


--
karatelovr
------------------------------------------------------------------------
karatelovr's Profile: http://www.excelforum.com/member.php...o&userid=27413
View this thread: http://www.excelforum.com/showthread...hreadid=469252