Hi Brainiacs,

Need your help again.

=TRANSPOSE(FILTER(A:A,ISNUMBER(SEARCH('New starters'!$C30,A:A)),"No Results"))

I am trying to hide the search results if 'New starters'!$C30 is a blank cell, at the moment it is populating the entire list in the transpose and I don't want it to do that.

Sadly where I work they don't yet have the excel build to search large data validation lists, so having to create a searchable list, but it means saving the excel sheet takes a couple seconds (which is huge from the split second it normally takes us to save a doc)

Unfortunately I can't create a dud sheet to upload, so hoping the above is enough.