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 .