To simplify, in my project plan I have a Column A "Activity", ColumnB "Function Title" and a column C "Resource Name" in sheet 1. I have a table in sheet 2 that shows the 1:1 relationship between the function title and the resource name. Say "Project Manager" = "Joe Smith", "Delivery Enablement Lead" = "Ken Jackson", etc...
In my sheet 1 Project Plan, I need to populate column C "Resource name" based on the value of "column B".
What's the easiest way to achieve this? Thanks for your help!!!
Stephanie
Bookmarks