SharePoint 2007 Supported Lookup Column Types

SharePoint only supports a couple Column Types for use with a Lookup:

Column Type Supported?
Calculated Yes
Choice w/ Checkbox No
Choice w/ Drop Down List No
Choice w/ Radio buttons No
Hyperlink No
Hyperlink w/ Picture No
Multiple Lines of Text No
Number No
Person or Group No
Single Line of Text Yes
Yes/No No

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.