To search and extract text from the search list

[ExcelNewbie2020]

Sirs,

In column A, i have a complete address while in column I i have list to search inside column A.. if the search is true, need to return the value from the search list

Untitled spreadsheet

docs.google.com

thanks

 

[Fluff]

How about

=FILTER($I$4:$I$7,COUNTIFS(A4,"*"&$I$4:$I$7&"*"),"")