Skip to main content

Lookup Column

A Lookup column creates a relational link from items in one SharePoint list to items in another list within the same site, displaying a value from the target list and optionally surfacing additional columns.

Common Use Cases

  • Project-task relationships: link tasks in a Task list to their parent project in a Projects list using a Lookup column, enabling task views filtered by project without duplicating project metadata
  • Client-matter relationships: connect legal matters in a Matters list to clients in a Clients list so matter records display client name, contact, and billing code pulled from the client record
  • Employee-department linking: build an employee roster that looks up department details (manager, location, cost center) from a Departments list for consistent department metadata across all employee records
  • Vendor-contract associations: link contract records to a vendor registry list so contract views display vendor contact, payment terms, and rating pulled from a single authoritative source

Benefits

  • Relational metadata without a database: Lookup columns create one-to-many relationships between SharePoint lists, enabling normalized data structures without building a custom database
  • Single source of truth for referenced data: updating a value in the target list (e.g., a department name) automatically reflects in all list items that look up to it
  • Additional columns from the target: a Lookup column can surface multiple fields from the target list item (e.g., showing both Department Name and Department Manager) in additional read-only columns
  • Filterable and sortable: Lookup column values can be used in view filters and sort orders, enabling views scoped to specific related records
  • Supports cascading filtering: when combined with connected web parts, a Lookup column can drive filtered list views where selecting a parent record filters related child records dynamically

Key Considerations

  • 12-column threshold: views combining more than 12 Lookup, Person or Group, and Managed Metadata columns, including the built-in Created By and Modified By, will be blocked; design views with complex column counts in mind
  • Source list must be on the same site: Lookup columns can only reference lists within the same SharePoint site.
  • Additional columns from Lookup are read-only: columns surfaced through the “Add a column to show each of these additional fields” option are display-only and cannot be edited directly