I was trying to make a lookup column in share point but not all of the columns were available for me to choose. Is there a way to expand the number of columns to choose from? Below is a picture of the lookup column settings I am trying to use.
Lookup column has limitations and it support only below types
- Single Line text
- Date and time
- Calculated single line text
- External Data