Look up and cross-reference information from any SharePoint site in a site collection.•Build parent-child relationships between columns in the same list so that data entered in one field filters the options presented in another,Use a combination of filter parameters from the source list and the target list to filter the items presented in a lookup field ,Automatically synchronize data and update items in the target list when changes are made in the source list.
Note:In a site we can have upto 8 look up fields.We can extend it through
throtting line which is existed in server.
