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, 2016 at 12:41
  • @GintasK Why you didn't add your comment as answer :) , it looks correct answer Nov 29, 2016 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, 2016 at 12:58
  • 1
    your help try is very appreciated :) Nov 29, 2016 at 13:01
  • 1
    He wanted to save the ID, the FK, so if the description changed, it would affect the FK relationship. How does one save the ID but present the description?
    – user88945
    Feb 10, 2020 at 18:45

2 Answers 2

  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.

I know this is an old thread, but that answer is incorrect - Gyonder wants the ID value to be brought across to his list, but he needs to display the description so that he can determine which one he needs.

I have a similar need - I want to get a unique value (ID) from another list, but I need to see the last name, first name and city when selecting the lookup item because the lookup list has multiple people with similar names. I don't want to add those values to my list, but I need to see them to decide which ID I need to select.

It drives me nuts that such a simple requirement has never been available in SharePoint lookups.

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