Search not searching each column in custom list

Question

Good Morning.

I have created a Custom List which is acting as a corporate directory. Using the search box in the "Standard View".

It will only search certain columns. i.e. First Name and Employee Number. It won't bring up any results if I search by Last Name.

Any help?

I am using SharePoint 2013 On Premise.

Thanks

Do you have data in last name field? Search takes some time to crawl the data and show in search results. When you have added data in last name column? — Ganesh Sanap, Apr 20 at 16:26
How are you searching for last name? "Smith" or "LastName=Smith"? Only the first will work unless you have setup Site Columns and Search Managed Columns. — Mike Smith - MCT - MVP, Apr 20 at 21:04
Why not use the built in people search page. It searches against the crawled User Profiles. — Matthew McDermott, Apr 21 at 0:15

Hellofiona_MSFT · Accepted Answer · 2019-04-22 07:00:08Z

You can troubleshoot the issue as following:

Go to Central Administration->search service application->Search schema->Crawled property, check if the relevant column name listed in it.
Go to site settings->searchable columns, check if the column is excluded from the site index.
Go to list settings->Advanced settings->click “Reindex list” button, then start a full/incremental crawl in search service application and check again.

1 Answer 1