Google Sheets Array Query

Hi All,

I'm trying to get an array to function that will search for a selection of words within a column and if the word is found place the row number in the column, if it doesn't contain any of the words it is left blank.
Obviously this can easily be achieved by dragging down an IF statement, but its 1000's of rows so it gets laggy!

List of words are :

Private
Public
Unlinked
Linked
Unavailable

Data is in O2:O
I want the array to be in P2:O

I have figured out how to search for 1 word, but adding more words in, even when incapsulated in { } does not work.
=ARRAYFORMULA(IF(ISERR(SEARCH("public",(O21:O)))=True,"",ROW(O21:O)))

This array sort of works, however it spills the values in to adjacent columns which I don't want.
=ArrayFormula(iferror(if(SEARCH({"private", "public", "linked", "unavailable"},O21:O),row(O21:O),""),""))

Any assistance is much appreciated.

Thanks in advance

Hi,
Sadly that doesn't work.

I think the issue is that in the other cells it has #VALUE!
I presume it uses 1 col per search word rather than just returning when it matches

eg :

#VALUE! 21 #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! 22 #VALUE! #VALUE!
#VALUE! 23 #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! 24 #VALUE! #VALUE!
#VALUE! #VALUE! 25 #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! 26
27 #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! 28 #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! 32 #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! 33 #VALUE! #VALUE!