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

We have a list, which contains schools with their names and addresses. We have another list, which has lookup field to that list on school name field. Since schools in different cities can have same name, when adding new item to the referencing list, user will see the same name twice and he will not know in which city that school is. Is there any out-of-the-box possibility that lookup field will render something like $SchoolName ($City) in the drop down list? Or any workaround?

share|improve this question
up vote 3 down vote accepted

You could create a calculated column to concatenate concatenate([SchoolName], " ([City])" the values on the school list and use that calculated field in your lookup. Verified it works in 2007, so it should work no matter what platform you're on.

share|improve this answer

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.