@Arvi
Looks like in this case the IF(ISERROR syntax is the way to go
The OP formula states that if the first FIND returns an error, it returns C2
If not it returns the concatenation.
IFERROR will not cope with this.
@14spar
Try adding=IF(C2="","",IF(Iserror....

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post