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: copy to clipboard 
=INDEX($B$1:$I$250,IFERROR(SMALL(IF($G$4:$G$253="_Voice & Data Outlet: Data Outlet",ROW($G$4:$G$253),""),ROW()-3),""),1)


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.