Working with Lookup in Microsoft Project


Lookups in Microsoft Project allow users to define lists of predefined values for custom fields, enabling consistent data entry and improving project management efficiency. This article explores how to work with lookups in Microsoft Project and provides practical examples.

What is a Lookup in Microsoft Project?

A lookup in Microsoft Project is a list of predefined values associated with a custom field. By creating a lookup, you restrict data entry to specific values, reducing errors and ensuring uniformity.

How to Create a Lookup Field

Follow these steps to create a lookup field:

  1. Go to the "Project" menu and select "Custom Fields."
  2. Select the type of field (Task, Resource, or Project) and the desired field type (e.g., Text, Number, or Flag).
  3. Click on "Lookup" to open the lookup table editor.
  4. Add predefined values to the lookup list.
  5. Save the changes and apply the custom field to your project.

Example 1: Task Priority Lookup

Create a lookup field for task priority to categorize tasks as High, Medium, or Low.

  1. Open the "Custom Fields" dialog.
  2. Create a new Text field called "Task Priority."
  3. Click "Lookup" and add the following values:
    • High
    • Medium
    • Low
  4. Apply the field to tasks in your project.

Example Usage:

Task Name       | Task Priority
--------------- | -------------
Foundation      | High
Superstructure  | Medium
Roofing         | Low
    

Example 2: Resource Roles Lookup

Create a lookup field for resource roles to specify the role of each team member.

  1. Open the "Custom Fields" dialog.
  2. Create a new Text field called "Resource Role."
  3. Click "Lookup" and add the following roles:
    • Engineer
    • Architect
    • Laborer
    • Supervisor
  4. Assign roles to resources in your project.

Example Usage:

Resource Name   | Resource Role
--------------- | -------------
John Doe        | Engineer
Jane Smith      | Architect
Michael Brown   | Laborer
Emily Davis     | Supervisor
    

Example 3: Status Lookup for Tasks

Create a lookup field for task status to track task progress.

  1. Open the "Custom Fields" dialog.
  2. Create a new Text field called "Task Status."
  3. Click "Lookup" and add the following values:
    • Not Started
    • In Progress
    • Completed
  4. Apply the field to tasks in your project.

Example Usage:

Task Name       | Task Status
--------------- | -----------
Foundation      | Completed
Superstructure  | In Progress
Roofing         | Not Started
    

Advantages of Using Lookup Fields

  • Consistency: Ensures uniform data entry across the project.
  • Efficiency: Reduces data entry errors and saves time.
  • Customization: Allows you to tailor fields to your project needs.
  • Reporting: Improves clarity in reporting by standardizing data categories.

Conclusion

Lookups in Microsoft Project are a powerful feature for maintaining consistency and accuracy in project data. By creating custom fields with predefined values, you can simplify data entry, enhance reporting, and ensure better project management.





Advertisement