• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

How do I show multiple values in a SharePoint 2010 Lookup box?

Does anyone know if it is possible to create a lookup column in SharePoint 2010 that shows multiple column values?  For example, I can get the lookup column to work and show entries from a list in my site, but i want it to show another column from that list as well.  I want it to show customer code AND the customer name that relates to that code....  Please see the image for an example.

All of the customer information resides in list.

 What I want...
0
dhshaw
Asked:
dhshaw
1 Solution
 
leopoldeCommented:
My suggestion is to create a new column that basically joins the values of the customer code and the customer name columns.  Then point your lookup to the new column.

The formula would be something like this:
=[Customer Code]&" "&[Customer Name]
0
 
dhshawAuthor Commented:
Thanks that did the trick!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now