I have sharepoint enterprise 2013 ..

I want to add a lookup column from other list ..

I added it but I want to show the drop-down column that I create it on the other list ..

I mean I have list1 and list2

list1 has many columns and has 3 drop-down column..

I want to add in list2 lookup column that bring all types of column in list1 ..

when I add lookup column and I add the column that I want to insert .. the drop-down columns didnt display I cant chose it

• Moved by Hemendra AgrawalMVP 3 hours 9 minutes ago SP 2013

If i am getting your problem then you want to achieve this->

1. You have List A and List B.

2. List A has 3 drop down columns.

3. You want to add a look up column in List B that brings all columns of List A.

4. When you add lookup column and add column that you want to insert, columns from List A does not get displayed in List B

am i right?

If yes then your solution goes here

1. No. Its not possible to get look up column on choice field.

But Yes you have 2 options.

1. Programmatic way.

2. Lazy work.

I can explain lazy work i like most as follows:

1. Create one more column in list A where you have another column of choice fields.

2. Scroll down and select Choice as reference for your calculated column.

3. now Create a Lookup column in List B and insert list A calculated column you just created.

4. That's it, you got the values.

Cheers!!

Please, don't forget to mark as answer, if it helps you!!

If i am getting your problem then you want to achieve this->

1. You have List A and List B.

2. List A has 3 drop down columns.

3. You want to add a look up column in List B that brings all columns of List A.

4. When you add lookup column and add column that you want to insert, columns from List A does not get displayed in List B

am i right?

If yes then your solution goes here

1. No. Its not possible to get look up column on choice field.

But Yes you have 2 options.

1. Programmatic way.

2. Lazy work.

I can explain lazy work i like most as follows:

1. Create one more column in list A where you have another column of choice fields.

2. Scroll down and select Choice as reference for your calculated column.

3. now Create a Lookup column in List B and insert list A calculated column you just created.

4. That's it, you got the values.

Cheers!!

I can't also take the caculated column !

Why you can't take the Calculated column.....

Is it available in list of options or not to use? or you don't want to use it?