Didnt get that to work but i found another way to find part of words.
=IF(COUNTIF(B1:C1;"*M*");A1;"")
So now i can search my M1-M13
BUT
Is there a way to get another criteria in to that code? like to search
for another code too.
--
Moffe
------------------------------------------------------------------------
Moffe's Profile:
http://www.excelforum.com/member.php...o&userid=30594
View this thread:
http://www.excelforum.com/showthread...hreadid=502440