5 Replies Latest reply on Jul 24, 2018 5:15 AM by Steve Wolfe

    Index(Match()) or VLookup Equivalent for Dataset

    Steve Wolfe

      Hello Tableau Community,


      I've found a couple of posts on VLookup capability, but I couldn't make any of the ideas fit my existing workbook.


      We have an Employee Tracker, where we track users by their UserID. Any time there's a new event, they get a new line on the table, recorded by the [Date Changed] header. I was able to get the Max [Record ID] value with the table calculation below (I can replicate A10:B11 successfully in Tableau):

      Tableau VLookup.png


      However, I can't figure out how to get the other values filtered based on that MaxID value. I get the error as shown below:

      Tableau VLookup.png


      Any help / direction you all could provide would be greatly appreciated.