|The FIND() function returns the #VALUE error if it does not find a match,|
and it is also case sensitive so your string Third Party is NOT the same as third party.
What you need to do is use the SEARCH() function, which IS NOT case sensitive,
so your string Third Party will match the string third party.
and you need to check for the error value first, so something like this should work:
message edited by mmcconaghy