SharePoint Cascaded Lookup helps users simply conduct cascading lookup, connected lookup, or filter lookup whatever you call it. This solution is very useful when you need lookup information from vast number of lists.

Here are its features:

1. Cross-site look up SharePoint lists in other sites ●
2. Build Parent-Child Relationship by filtering SharePoint columns ●
3. Filter looked-up column by Filter Column in the looked-up list ●
4. Filter looked-up column by Parent Column in the Cascaded Lookup Column residing list ●
5. Two-way conversion to default SharePoint Lookup Column type or SharePoint Cross-Site Lookup Column type ●
6. Support filtering multiple-values Cascaded Lookup Column

More information please visit