In MyList I have a lookup column that is populated with values from a list with columns ID,DESCRIPTION

When a user inserts a new item the dropdown box only shows ID values.

enter image description here

I would like to see the DESCRIPTION instead as a user can't remember every ID.

How can I do this?

  • 4
    List Settings -> Your lookup field -> "In this column:" choose "Description" – Gintas K Nov 29 '16 at 12:41
  • @GintasK Why you didn't add your comment as answer :) , it looks correct answer – Mohamed El-Qassas MVP Nov 29 '16 at 12:55
  • 2
    @M.Qassas I didn't quite catch the question as this is too simple, it was just a guess as I thought OP requires both ID & Description in the drop-down :) – Gintas K Nov 29 '16 at 12:58
  • 1
    your help try is very appreciated :) – Mohamed El-Qassas MVP Nov 29 '16 at 13:01
  1. Go to list setting
  2. Create new column or alter your existing column.
  3. Choose type as Lookup
  4. Provide your list name from where you want to lookup in "Get information from:" drop down.
  5. Now choose your 'description' column in "In this column:" drop down and you are done.

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.