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

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

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
    • #416263
      Mike Levine
      Member

      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
      Larry Christofaro
      Participant

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

Viewing 1 reply thread
  • You must be logged in to reply to this topic.