SharePoint Web Parts
& Office 365 Apps
by VirtoSoftware

SharePoint Cross-Site and Cascaded Lookup

Virto Cross-Site & Cascaded Lookup is a powerful tool intended to joint display of associated data from several SharePoint sources including its lists and sites.

Get your free trialSend me download link Buy now
5 stars - based on 2 reviews / share your feedback
Overview

Virto SharePoint Cross-Site & Cascaded Lookup is a powerful feature which allows both referencing and cross-referencing existing data in SharePoint 2019, 2016, 2013, or 2010 List across current site or site collection. It is a part of Virto SharePoint Content Management Suite and Virto ONE License.

1
Cross site lookup function

Virto Cross Site & Cascaded Lookup allows you to referencing and cross-referencing existing data from different SharePoint sites and lists in the lookup column. Also, you can set up dependencies and create parent-child relationships between columns in the same list so that data entered in one field filters the options presented in another.

2
Convenient searching system with autocomplete

Find-as-you-type function allows you to select objects by one keystroke. The result of search in the dropdown list is filtering by letters that you type in the moment.

3
Filtering data by column and by view

WithVirto SharePoint Cross-Site & Cascaded Lookup, you can quickly filter large data set from the list by pre-defined view and refine the values for selection. Besides that, you are able to filter retrieved data by columns from the target list. Virto Cross Site & Cascaded Lookup allows to quickly operate large data set and supports large number of items per list (>2000).

4
Remove Duplicate Items

Virto SharePoint Cross-Site & Cascaded Lookup features multiple values and duplicate values removal, so you always get only one instance without overlapping.

Virto Cross Site & Cascaded Lookup is a powerful tool intended to use for SharePoint information, and for joint display of associated data from several distinct sources including lists and sites. The component quickly cross-references existing data from a list or site and then applies a combination of filters to reduce the number of options presented in the drop down menu of your lookup field and eliminating the possibility for error as a result of incompatible values.

How to use Cross Site Lookup

As an example, we will do a case where you need to aggregate information from a list of clients which are grouped by countries and cities. We have created three lookup fields with the dependence country -> city-> client. This means that when a user adds a new item to the list, he selects a country and a list of cities of the country will be displayed accordingly. And when the list of cities is defined, the same happens with clients list. Enter title of the lookup and start typing a country name. The list of countries will be displayed. Click on the required country and use the arrow button to add this country to the lookup. As you add countries to the lookup, the list of cities will change accordingly. And as you select cities, the list of clients will change as well.

Though there are a number of products that offer the same functionality on the market, Virto Cross Site & Cascaded Lookup has a set of clear advantages. First, it integrates features of two distinct components, Cross Site Lookup and Cascade Lookup. Second, it provides users with additional features like advanced filtering and displaying additional columns for loo kup list items.

Virto Cross Site & Cascaded Lookup is the only product that effectively combines two components: provides users with extended tools for advanced displaying of SharePoint data, and with a cost that is less than the majority of SharePoint web parts with similar functionality.

Learn also about 50+ great SharePoint Web Parts we’ve prepared for you!

Features
Latest releases
System requirements
SharePoint version: 2019
Operation system:
Server:
Browser:
Features
Cross-site look up of list from current site collection Using Virto Sharepoint Cross-Site & Cascaded Lookup, you can both referencing and cross-referencing existing data in SharePoint 2016, 2013, or 2010 List across current site or site collection.
Ability to set dependence between look up fields Virto Cross Site & Cascaded Lookup allows tou to create parent-child relationships between columns in the same list so that data entered in one field filters the options presented in another.
Multiple selections can be applied to lookup fields Virto Cross Site & Cascaded Lookup allows you to apply multiple selections for lookup fields
Conversion of Standard Look up to Virto Lookup Choose convenient interface for a work with SharePoint data.
Multiple values and duplicate values removal Virto Cross Site & Cascaded Lookup is able to filter out duplicate values and display only one instance.
Datasheet View Support Virto SharePoint Cross-Site & Cascaded Lookup supports Datasheet View
Large number of items per list support Virto Cross Site & Cascaded Lookup can quick and efficient operate the big SharePoint data with thousands of elements.
Resources
SharePoint Forms Designer latest version allows you to display “Virto cross-site lookup” field type in your SharePoint forms.

Now you can add any cross-site lookup column to your custom form in SharePoint 2013 (Virto SharePoint Cross-Site and Cascaded Lookup feature is required) and create beautiful and convenient forms for any business need!...
Blog
A single view to collect the latest updates from distinct project sites

Business Requirements

Collect the latest information from various sources in a single place
Virto Software Components Used

SharePoint Workflow Activities Kit; SharePoint cross-site lookup....
Blog
Accelerate your sales cycle by using a set of powerful tools for marketing automation.
The sales team is the key revenue-generating unit in any business. To increase productivity, the company`s sales management team requires well-defined and optimized processes with real-time visibility. By automating both simple and sophisticated business requests, your sales team ensures maximum efficiency and profitability....
Blog
Purchase
Step 1
Choose your SharePoint Version
Step 2
Product or Bundle?
Number of WFE’s
Virto ONE License
Annual subscription
1 S/N for all products
Free Standard + support
$4308per WFE
OR separate product
Cross-Site and Cascaded Lookup
Perpetual license
$599per WFE
Step 3
Select Professional Services Level Package
Our SharePoint and Office 365 Experts will consult, train your team on efficient using of SharePoint platform, Virto products, itsadd option to your business processes, will help to determine key area of improvement.
Basic
Standard
Standard Plus
Premium
Included services hours
2
4
8
16
Minor and major upgrades
Helpdesk & Email support
Phone & Remote support
Development services
Response in hours
48
24
24
Same day
$0
$495
$0
$1995
Need a Quote or have a questions?
Total - $0

After you press "add to cart" button you will be forwarded to secure zone of our processing partner avangate where you can select qty and finish checkout.

License notes and renewal

Upon purchase, your license comes with a free 1-year update period. Once this initial period expires, an extension for a further year needs to be purchased to maintain access to the latest product updates.

Educational and non-profit discounts

We are glad to offer a set of special discounts for schools, colleges, universities, hospitals and charity organizations. Please contact our sales department for more information.


Feedback
May 16, 2019
Easy way to add cross site lookup column to SharePoint list.
January 28, 2019
Great feature for SharePoint cross site working! Particularly, i like the auto complete ability in this web part!