SharePoint Cross-Site Lookup provides additional features beyond the default Lookup function of SharePoint 2007. These features include:

1.Allow users to refer to a lookup list from a different site in one site collection.
2. Support conversion from Cross-Site Lookup column to default Lookup type; therefore, altering the content of Cross-Site Lookup column in datasheet view will be achieved.
3.Find-as-you-type function makes all the objects which are listed in the Dropdown list with the same letter as input word shadowed and chosen quickly.

Default SharePoint list settings support intra-site lookup function but cannot meet end users' demands when it comes to looking up some information on other sites in the same site collection.

On the other hand, most Cross-Site Lookup can't be converted to default SharePoint Lookup column type so that many users feel inconvenience when they need to change content of Cross-Site Lookup column in datasheet view.

When users choose objects from dropdownlist of lookup column, they often have to scroll down through all the other objects. Find-as-you-type function is an enhancement tool for improving efficiency in the case of this problem.