Home Forums Discussion Project 2016 (local) : How to access the Description data in a Lookup Table

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by Larry Christofaro Larry Christofaro 1 month, 1 week ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #416263 Reply

    I created a custom lookup table with 47 values and descriptions and I want MS project to display both the value selected from the drop down and the description.

    Example:
    AN – Analysis

    The alternative is to have two columns, one that is the lookup table and the second a formula that populates the description based on the value in the first column.

    Is there a non-VBA solution?

    I’ve tried the nested iif([]) route and there are more than 255 characters in the formula and not working and the preference is something more dynamic than embedding values in a formula

    #416264 Reply
    Larry Christofaro
    Larry Christofaro
    Participant
    • Expert
    • Forum Pro
    • Ombud

    Other than combining the description with the code or using two fields, I don’t know of any other option…

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Project 2016 (local) : How to access the Description data in a Lookup Table
Your information:




− 2 = 5