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

In SP2010,

I want to get 2 columns from another list and merge these columns. But when I am trying to do this via Lookup, they are not shown under "Add a column to show each of these additional fields".

But when I tried a simple text one (not lookup) it is shown.

Is there anyway to show a column which a kind of lookup field?

share|improve this question
up vote 12 down vote accepted

I gather that you're trying to use a lookup to 'bring in' additional fields to your current list, but that they aren't available to select.

Some field types are not available for this sort of function. For example, further Lookup fields can't be brought in.

Also, notably and annoying, neither can Choice fields. This was possible in SharePoint 2010 before SP1, but after SP1 it seems to be no longer possible. I can't see a good reason why, and it is very annoying.

There is no way of making additional types of column available in the look up control as far as I know.

share|improve this answer
thanks Andy, i googled it alot and there is really no way to use looked up columns in additional fields. Its bad :/ I must find another way. – alicanbatur Jun 27 '12 at 10:44
+1 for the note on choice fields. Apparently a workaround is to copy the choice field to a calculated column – Christophe Aug 29 '13 at 22:57

I found a work around for this, what you do is use a wf to move the column into a text field. Go the origional list that has the information you'd like to look up. Creat a new text column and give it a name similar to the one you would like to dupilicate. Then create a WF to auto-populate that column into a text field. You can then look that column up in any other list.

share|improve this answer
Yeah, this is what we do as well. – PeterX May 22 '13 at 6:15

Not all fields are supported as lookup fields. I tried to find a supported fields list but didn't find one. While searching though I ran across this discussion which offers a fix for columns that aren't supported such as choice fields.

share|improve this answer

Not as far as I know - which is why it doesn't show.

share|improve this answer

How about this as a solution,

Say the choice column that you want to use is called 'My Choice', create a calculated column with the formula [My Choice] then this calculated column is available in the "Add columns to show additional fields" options. This will probably also do for a look-up column too.

It seems to work for me but I'm sure Microsoft will find a way of breaking this in the next service pack.

share|improve this answer

It was very annoying not be able lookup currency column, however I found this workaround that worked in SP 2013.

  1. Create calculated column of type "Single Line"
  2. Use formula to format text as currency =TEXT([Price],"$0.00;($0.00)")
  3. Now this new column can be referenced as secondary column and visible in the list.
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.