Let's say you have a contact list that contains the columns: Fname, Lname and Phone#. In another list you would like to lookup this list by the combination of Lname and Fname and a space between them to get the contact's Phone#.
Add to the source list a calculated column of type text with the formula:
=Fname&" "&Lname.
Now you can create the Lookup Column in the target list pointing to the newly created 'FullName' column.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Enter your comment here