I have simple Sharepoint list named Alist with lookup value column.

the lookup value column returns fields from other list named Blist. accidentally I have deleted this Blist and in Alist all lookup value disappeared, after I created new Clist identical to Blist.

now I am interested in how to change lookup reference from Alist to Clist?

1 Answer 1



You cannot change the lookup settings from Blist to Clist for the existing column.

In your Case you need to create new lookup column with reference to Clist.

Note: Creating new lookup column will loss all existing data of lookup from Alist.

  • but I want to restore lookup data in Alist Jan 10, 2019 at 6:41
  • Do you have any backup from Alist? Any saved list template? Jan 10, 2019 at 6:48
  • I have Alist with disappeared lookup column, and deleted Blist's identical Clist. Jan 10, 2019 at 7:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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