Search 2 words in one sentance + Identify them

Hello everybody, I'm French and it's my first time in this forum.

I've one problem, I'm going to try explain it to you :




My sentance it's on cell B.


=>>> I would like identify two animal in my sentance according to a little board "possible animals". According to the order of reading of this sentance, i would like rewrite both animals in cells un Anim1 and Anim2

Aide for eng.xlsx


I've write in target cells for an exemple but columns E and F are normaly empty...

I'm sory because i'm not very fluent in english but I improve myself over time.

I can answer in your question if you have it.

Thanks a lot.

AllanHub

if you're ok if they are not in the right order

Hello Alan,

I'm grateful for your work ! I'm so sory but my target it's to get the name in right order Do you have an other idea ?

Thanks a lot !!

AllanHub

this works with your sample data

Hi everybody !

Lot of solutions work !! Thank you so much ! I'm grateful for your work

"Bravo"

AllanHub