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

[Mike Levine]

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

[Larry Christofaro]

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

[Author]

Posts