User friendly solution than hard coded keyword lookup?

[Wad Mabbit]

I've set up this table, called PickDescription:

and this one, called PickNotes

using this lookup to check for Keywords in Notes Keywords, then Description Keywords, returning [Description] if no match:
=IFNA(INDEX(PickNotes[Category],MATCH(TRUE,ISNUMBER(SEARCH(PickNotes[Notes Keywords],[@Notes])),0)),
IFNA(INDEX(PickDescription[Category],MATCH(TRUE,ISNUMBER(SEARCH(PickDescription[Description Keywords],[@Description])),0)),
[@Description]))


Questions 1:
Is there a way to do this without using an array, as arrays are volatile?

Question 2:
It would be nice to have multiple entries in the Keyword columns, rather than lopts of rows for the same Category listing. Any ideas?

 

[Wad Mabbit]

Fixed, with help from BSALV on another thread:
=IFERROR(INDEX(MyDescription,1/(1/MAX(ISNUMBER(SEARCH(MySearch,[@Description] & "|" & [@Notes]))*ROW(MyDescription)))),[@Description])

..Ditched the Notes table and am just using a single table. highest row number has priority