( by HAM10 )
I've transferred a telephone directory created in Excel to Google Sheets with approx 2400 entries.
I would suggest to insert a new sheet in your Spreadsheet, and you can name it 'Search Sheet'. Have a look at the following Screenshot of my 'Search Sheet':
Now put any search term like "abe" in Cell B1 as you can see in the above screenshot and put the following formula in Cell A3:
=iferror(query(arrayformula(upper('Phone Directory'!A:E));"select * where Col1 contains '" & upper(B1) & "'");"No Records Found...")
The above formula will fetch all the results from Sheet 'Phone Directory' that has "abe" as a part of string in Column A.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.