Sharepoint - Why is my column not shown under “Add a column to show each of these additional fields”?
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.
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.
It was very annoying not be able lookup currency column, however I found this workaround that worked in SP 2013.
- Create calculated column of type "Single Line"
- Use formula to format text as currency
=TEXT([Price],"$0.00;($0.00)") - Now this new column can be referenced as secondary column and visible in the list.