With the recent user experience improvements for the Lookup column, I got a great question from one of my clients the other day. The question is this: what makes the most sense to use: Lookup column or Managed Metadata (Term Store) column?
https://sharepointmaven.com/lookup-column-vs-managed-metadata-column/
Though I am a huge advocate of metadata, one column type that I have never blogged about previously is the Lookup column in SharePoint. The reason for this is that it is a unique type of column you would only use in very rare scenarios, and it does come with limitations.
https://sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/
Before we jump to the topic at hand, a little recap of the terminology involved: