Mary,
Try this.
=SUMPRODUCT((ISNUMBER(SEARCH(A1,Sheet3!$A$1:$A$4,1 )))*(Sheet3!$A$1:$A$4))
This is where A1 is your partial code and Sheet3!A1:A4 is your complete
codes. Copy this down your list of partials. This also assumes that
your partials will be unique to only one complete code.
Does that help?
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=539879