Quote Originally Posted by sonar123
Can the formula be modified so if there is only one IC Prov, it does not return nothing, but returns the first one it sees?
Perhaps

=IF(COUNTIF($I$1:$I$83,"IC Prov   ")=0,"",INDEX($W$1:$W$83,SMALL(IF($I$1:$I$83="IC Prov   ",ROW($I$1:$I$83)-ROW($I$1)+1),MIN(2,COUNTIF($I$1:$I$83,"IC Prov   ")))))
confirmed with CTRL + SHIFT + ENTER
Regards removing trailing spaces - possibly but that rather depends on the exclusivity of the search terms (use of wildcards in the COUNTIF etc)