Users can add one or more filters to build multiple cascaded relationships for the Cascaded Lookup column. The number of cascaded levels is not limited.
The lookup items of the Favorite Companies column are filtered by Location column, Industry and Company Size column in current list.
Users can add multiple filters for the Cascaded Lookup column.
The lookup items of the Favorite Companies column are filtered by the Location, Industry and Company Size columns from the source lookup list.
Users can add new items in the source lookup list by clicking the “Create new item…” link.
Show additional fields from the source lookup list, and the column order can be customized.
With SharePoint Cascaded Lookup 4.0, you can now manage Cascaded Lookup
Column data in Microsoft Office applications like Excel, Access, Word and
By default, SharePoint only can manage out of the box column data in Microsoft Office applications. Cascaded Lookup 4.0 enhances the functionality of SharePoint and provides the ability to manage Cascaded Lookup columns in Microsoft Excel, Microsoft Access, Microsoft Word and SharePoint Workspace.（Please check Technical Notes for more details）
|Feature List||Cascaded Lookup 4.0||Cascaded Lookup 3.0|
|Build single parent-child relationship|
|Set combination of filters on the source or target list to filter items in lookup field|
|Display selected columns of the source list in view item form|
|Conversion among SharePoint Lookup column, Cross-Site Lookup column, and Cascaded Lookup column|
|Keep Cascaded Lookup settings when converting into SharePoint Lookup column|
|Filter lookup items by view|
|Support look up items by folder mode|
|Remove the duplicated lookup items|
|Build multiple parent-child relationship, No limitation on number of cascading levels|
|Support filter lookup items by multiple columns|
|Support look up information from "Date and Time" and "Number" columns|
|Support Multiple Choice, Multiple SharePoint Lookup, Multiple Cross-Site Lookup, Multiple Cascaded Lookup columns as parent column|
|Support displaying additional columns from lookup list|
|Support adding new items in the source lookup list by the “Create new item…” link|
|Support Cascaded lookup as site column|
|Improved lookup performance|
|Support export Cascaded Lookup column data to Microsoft Excel|
|Link SharePoint list to Microsoft Access database, support view and edit Cascaded Lookup column data|
|Support export Cascaded Lookup column data to Microsoft Access database|
|Support manage Cascaded Lookup column data in Microsoft Word|
|Support sync Cascaded Lookup column data to SharePoint Workspace|
Need to look up information from list in other site and filter Cross-Lookup field by selecting list views?
SharePoint Lookup enhancement tool consists of SharePoint Cross-Site Lookup and SharePoint Cascaded Lookup.
Trusted by over 4000 companies