1 Reply Latest reply on Jun 1, 2015 2:53 AM by joe.s.

    Index-Match-Match for Matrices - Please help!

    Adam Yasinow

      Hi Tableau Community,

       

      I am a new user to Tableau and need some help navigating/mining a matrix in a fashion identical to Excel's "Index(Matrix, Match(Row), Match(Column))" function.  Specifically I need to Tableau to pull the appropriate cell in a matrix when both the row and column are undefined. 


      Please see attached excel workbook for a clear example of what I'm looking to accomplish.  Specially I'm looking to replicate the formula in column C in Tableau. Thanks for your help!