0

How to search another project file on project server with a VLOOKUP type funct

Home › Forums › Microsoft Project Discussion Forum › How to search another project file on project server with a VLOOKUP type funct

Viewing 1 reply thread
  • Author
    Posts
    • 05/29/2017 at 4:58 am #410142
      Torstein Kongshem
      Guest

      I have a need to lookup a unique id in another schedule and pull task information from that schedule, basically Task name, Start and Finish dates, and Notes. I was looking for a way to use VLOOKUP type formula, like it works for MS Excel, but couldn’t find it. Anyone got an idea on how to solve this ? Appreciate an answer !

    • 05/29/2017 at 9:52 am #410144
      Avatar photoLarry Christofaro
      Participant

      Torstein, this is a simplified solution but you could link to the task as an external task. External links have some caveats but does bring in the fields you want. Let me know if that is something you know of or considered, or if you know that won’t work.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.