Multiple Values and Duplicate Values
Check the box “Allow multiple values” in case you need to enable multiple values in your lookup. Allow multiple values is available when the source list is in the current site collection. For a source in another site collection or web application the column holds one value.
Check the box “Remove duplicate items” if you need to exclude duplicated items from the lookup. Remove duplicate items hides the values whose shown text repeats (the Display Column together with the Show other columns values). Only the first of the matching source items is offered, and the column stores a link to that item.
