My question is if there is a way to combine the SEARCH function with VLOOKUP or INDEX and MATCH. I know how to use SEARCH to find where "Library" starts in "AL Public Library" but what I want to be able to do is search a column for text and have it return all results where the text I enter is in the cell. This way, if I type "Library" every cell with the word "Library" somewhere in it will be returned. I hope this explains what I am trying to do. I am attaching an example to help explain further.