You have a lookup table with 240 values and you scratch your head and think “am I really going to type out all these values, or is there a better way?”. Yes, there is a better way and this involves bringing over the field/lookup table from Project Professional, where you can copy paste the entire list of values in. Here are the steps:
To accomplish this, I completed the following steps:

  1. Open Project Professional connected to the appropriate environment
  2. Open a blank project : New > Blank Project
  3. Right click on a column header and insert a Text field (Text10 for example)
Figure 1: Right click on a column header and insert a Text field (Text10 for example)

Figure 1: Right click on a column header and insert a Text field (Text10 for example)

  1. Right click on Text10 Column and select Custom Fields
Figure 2: Right click on Text10 Column and select Custom Fields

Figure 2: Right click on Text10 Column and select Custom Fields

  1. In Custom Fields pop up, go to Custom Attributes section and select Lookup
Figure 3: In Custom Fields pop up, go to Custom Attributes section and select Lookup

Figure 3: In Custom Fields pop up, go to Custom Attributes section and select Lookup

  1. In Lookup Table settings, you can either enter values in each row OR paste values from an Excel or other location. This saves a lot of time if you had 100s of values that you needed to add.
  2. Once you’ve entered all values, click Close at bottom.
Figure 4: In Lookup Table settings, you can either enter values in each row OR paste values from an Excel or other location.

Figure 4: In Lookup Table settings, you can either enter values in each row OR paste values from an Excel or other location.

  1. Now that the field and values are setup, we can add this to PWA by clicking on Add Field to Enterprise.
Figure 5: Add this to PWA by clicking on Add Field to Enterprise

Figure 5: Add this to PWA by clicking on Add Field to Enterprise.

  1. Now you have option to name field and lookup table, then click Ok.
Figure 6: Name field and lookup table, then click Ok

Figure 6: Name field and lookup table, then click Ok

  1. Once field has been added you will see this message:
Figure 7: The field was successfully added to Project Web App

Figure 7: The field was successfully added to Project Web App

  1. Click Ok on the pop up, close out the Custom fields dialog box and close out the project
  2. Navigate to PWA > PWA Settings > Enterprise Custom Fields and Lookup Tables
Figure 8: Navigate to PWA > PWA Settings > Enterprise Custom Fields and Lookup Tables

Figure 8: Navigate to PWA > PWA Settings > Enterprise Custom Fields and Lookup Tables

  1. Scroll through Custom Fields and Lookup Tables section and you should now see a new field and a Lookup Table that was created.
Figure 9: Scroll through Custom Fields and Lookup Tables section and you should now see a new field and a Lookup Table that was created.

Figure 9: Scroll through Custom Fields and Lookup Tables section and you should now see a new field and a Lookup Table that was created.

You can repeat these steps if you have other Lookup Tables you need to bring in. Enjoy!