SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to look-up anything but single line text values when creating a lookup column?

E.g. I have a list with some general data ind it, one of the columns contains numbers. They should form the basis for a column in another list, but when I try to create the lookup, I can't select the column in question.

share|improve this question
up vote 3 down vote accepted

It filters the column list down to just the text fields. You can probably define a custom field type that may be able to overcome this.

share|improve this answer
yep it smells like a custom field type – Anders Rask Feb 10 '10 at 21:58
I'm surprised more custom fields are not defined. There are some great possibilities here, particularly with lookups. – Mike Oryszak Feb 10 '10 at 22:32

You could create an event receiver on the lookup list that copies the numberic values (OnItemAdded, OnItemUpdated) in its string representation into a text field which you can use for your lookup.

share|improve this answer
I was looking for a solution thats doable by super users but it doesn't seem plausible in this case – noesgard Feb 11 '10 at 9:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.