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!