从excel表中的短语列动态填充字符串数组

I have 2 sheets. I am using a user-defined function in sheet 1, in which I want to use an array to compare some strings. The array is comprised of the contents of a column of cells in the second sheet (which is named "phrases."). I have 2 sheets. I am using a user-defined func