From the course: Microsoft Project Quick Tips

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Enter values quickly with a lookup table

Enter values quickly with a lookup table

From the course: Microsoft Project Quick Tips

Start my 1-month free trial Buy for my team

Enter values quickly with a lookup table

“

- [Instructor] With a lookup table, you can enter data quickly and without errors. To create a lookup table, right click the custom field heading in a table and then choose custom fields. The custom fields dialog box opens and selects the custom field you right clicked. Beneath the field list, click lookup. In the value cells, add the standard values for the field. Press enter after you enter each value. You can add descriptions if you want to provide context. To set a default value, turn on the check box labeled use a value from the table as the default entry for the field. Click the value in the list and then click the set default button. The default value turns blue. When you create a new task, Project fills in the default value automatically. When you're done with a lookup table, click close, and then click okay. To use a lookup table, click the cell and then click its down arrow. When the dropdown list…

Contents