12 Replies Latest reply on Jan 6, 2016 11:23 PM by Emily Z

    What is the formula to use

    Emily Z

      Hi,

       

      I understand that Tableau can achieve vlookup between two sheets by data joint or data blending, or within one sheet using calculation. However, I do not know what formula to use to achieve the target result (E PM) in below table.

      Project TypeProject CodePME PM
      EP1010E01TomTom
      RP1010E01R01TomTom
      RP1010E01R02JerryTom
      EP1010E02AlexAlex
      RP1010E02R01JohnAlex

       

      Basically I want the PM of R Projects (Project Type=R) to be replaced by PM of its corresponding E Projects.

       

      Pls. help!

       

      Thanks!

       

      Emily