Does SharePoint Search Index Multi-Value Lookup Columns?
Question details
Determine how SharePoint search handles a multi-value lookup column and investigate missing results when multiple values are selected.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- A user searches for items using values from a lookup column that allows multiple selections.
- Observed behavior
- An item may appear when one lookup value is selected but not return the expected result when multiple values are selected.
Identify whether you are using classic or modern SharePoint search and note the exact search terms. You may need permission to view list settings and the search schema.
Compare Search Results and Verify the Lookup Configuration
Use this investigation when an item is found with one lookup value but not with multiple values.
Multi-value lookup search behavior can differ from single-value lookup behavior, especially in classic search. The result also depends on how the lookup data is crawled and mapped in the search schema, so this test alone does not establish that every selected value is independently searchable.
Open the affected list, select Settings > List settings, and open the lookup column under Columns. Record the source list and whether multiple values are allowed.
In the list, open an item with one selected lookup value and another with multiple values. Record their titles and selected values, then use the same search box to search for each value separately.
Note whether the search page is classic or modern, the exact queries entered, and which items appear or are missing. Capture screenshots of the lookup settings and search results.
Ask a SharePoint search administrator to open the applicable Search schema settings and inspect the crawled and managed properties associated with the lookup column. Confirm whether the managed property is configured for the type of query being used.

Distinguish a List Column Index from Search Indexing
Use this check if the question is whether the lookup column can be indexed for list filtering rather than found through SharePoint search.
Work with Office Files in WPS Office
WPS Office is a free, lightweight alternative for working with Office files in a familiar interface. Its format compatibility helps you move existing documents, spreadsheets, and presentations into your workflow, though it does not change SharePoint search indexing.

Frequently Asked Questions
Can I add a list index to a multi-value lookup column?
No. Multi-value lookup columns cannot be used as indexed list columns. Go to List settings > Indexed columns to review existing indexes and choose a supported column for filtering.
Does a list column index control whether lookup values appear in search?
No. List column indexes and the search index are separate. For search behavior, an administrator should inspect the applicable Search schema and the crawled and managed properties associated with the lookup column.
How can I test whether each lookup value returns an item?
Record the values selected on a test item, then enter each value separately in the same SharePoint search box. Compare the results with an item that has only one lookup value selected.
What should I provide to support if results are missing?
Provide the classic or modern search experience, exact queries, affected item details, and screenshots of the lookup configuration and search results. Remove sensitive information before sharing screenshots.




