Home › Forums › Discussion › 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…
Mail (will not be published) (required):
Please complete this equation so we know you’re not a robot. − 5 = 1
Please enter your username or email address. You will receive a link to create a new password via email.
Enter the destination URL
Or link to existing content