搜索范围内的数组数据类型字符串时出错

I have an array of strings. I also had a worksheet containing two columns, first column contains the strings from my array and the second column contains the numeric code associated with the first column. I need for a subset of the array to find, their associated codes. I tried the following but it does not work. I have an array of strings. I also had a worksh