Divide comma-separated string and look up corresponding category
 

Bernie,
MS Excel MVP indeed! Your macro worked beautifully. The only proble
I had was frustration that I didn't figure out how to do it myself.
Thanks so much for your help.

kmb

--
kmb
-----------------------------------------------------------------------
kmb1's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27249