Home › Forums › Discussion Forum › Project 2016 (local) : How to access the Description data in a Lookup Table
Tagged: Lookup Table
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
Other than combining the description with the code or using two fields, I don’t know of any other option…