And if you are using a post 2003 version as you indicate in your info, you can replace (If(iserror with IFERROR

__________________
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

I am sorry if I was not clear enough.
If you look at the example, the formula works by looking 1 criteria for example "mouse" but I need to look in the same column for " mouse, dog, cat, sheep and horse" (or whatever 5 I put). I want to return all the formula finds of those 5 in a column (e1:e20 for example) instead of having to copy the formula across for each one of the items I need to find as you understood .