Match multiple repeating strings in a column and output the row number

I have provided a sample file below. I am currently using several functions to try and search the column Family and Type for a specific string. Using the following i have been able to find one specific cell value and output the Space Number in the same row.

Formula:

Please Login or Register  to view this content.

I would like to be able to search for three values. "_Voice & Data Outlet: Data Outlet", "Floor Flush Data Drop: Floor Box", and "_Voice & Data Outlet: Voice & Data Outlet" The goal would be that it was sequential so that as you go down Column G if it encounters any one of the three it will output the Space Number.

I tried using the OR function within the IF logic statement and was not getting my desired result.

The sample file has the data and an example of my desired result compared to my current result.

excel help 3nw export.xlsx

Thanks in advance for your help and advice.

Are you referring to when OR is used within the if statement?

I get the same result when I try something like this:

Formula:

Please Login or Register  to view this content.

That's where I am stuck.

WirelessRouter - CLG: ) should not be true with the OR function but for some reason it appears to be. It is strange because it is not one of the OR conditions.

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.