Formula that will find the FIRST word from a list of words to appear in a cell?

I have data dumped in cell A1. Raw text and some numbers.

There is a range of words in Z1-Z10 that would trigger the identical action if found in A1.

NOTE 1: It is entirely possible for several words from the Range in Col Z to be in A1.

NOTE 2: It is entirely possible for those words to appear multiple times in A1.



I need a formula that will find the FIRST INSTANCE OF ANY OF THE WORDS ON THE LIST.

So, I don't need the first occurrence of each word. Just the first word in the Range to appear, period. "King of the Mountain" style here.

I know I've done something similar to this before, but I am drawing a complete blank here...

thanks,

RJW

Happily @FDibbins.

Thanks for all of your help!

RJ

Hi FDibbins,

And it's not horrible at all!

I looked into this elsewhere but was naively hoping I could avoid the CTRL+SHIFT+ENTER solution because this will be used so often I would ideally like to see it self populate if you know what I mean. But it does work!

Thanks for the help!

rjw