Thanks again for taking the time to reply. This has been an interesting challenge. I've attached a worksheet with both formulas as you've suggested. The intent of this worksheet is to score each of the highlighted columns using this formula. As you can see it is not working as planned, there must be something I'm not doing right or something I've missed telling you as it does on paper seem fairly straight forward. I think what I missed telling you is I am searching for a string within a string which Match may not be able to do? The search string would contain more than just the item being searched for.

thanks again
d