Lookup last text from the column or row but exclude certain words

Hello,

This is probably easy but I can't still figure it out.

I wan't to lookup (or use other similar method) the last text or value from a column or row. For this, there is a function like =LOOKUP(2,1/(B3:I3<>""),B3:I3). But how do I exclude two different words for the search?

For example, I want the last word from the row to be displayed in column J so that it is not dog OR cat (basically the ones highlighted in green should be displayed).

Any ideas?

Thanks in advance.

Try:
=LOOKUP(2,1/((B3:I3<>"cat")*(B3:I3<>"dog")*(B3:I3<>"")),B3:I3)

Good luck!

Thanks, works perfectly!

You're welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!