I have attached a simplified data set.

excel help 3nw export.xlsx

Please take a look at column J and Column L. These columns show the current result i am getting and what my desired result is.

I want to look at each row in column F and if it matches one of the strings i am looking for it will return the Space Number in Column A. This is done using the Index function.

I am finding the row number of each instance i am searching for and using it as the row number in the Index function. The column Number in the Index function is fixed to column 1 of the array beacuse it is Column A.

I hope this helps.

Again please look at column J and Column L this should show you what i am trying to acomplish.