Index / Match Formula?

7.79K viewsFormulas and Functions

I am trying to replicate the Excel functionality of using an INDEX / MATCH formula.

I have a Quantrix matrix with rows, columns, and data in the middle (three categories). I want to look up a data value based on two different criteria, one from the row and one from the column.

In Excel I could accomplish this using an INDEX / MATCH. I would use two MATCH formulas to find the row and column that satisfy my criteria, then use INDEX to pinpoint the intersection of that row and column.

Quantrix has the MATCH formula but not INDEX. Any ideas on how this could be accomplished?


Attached is an example. I have a reference matrix (“Stock_to_Sales”) with two dimensions: Ratio and Velocity. For each Ratio / Velocity combination, there is a Service Level %.

The user will input a desired Ratio and Velocity in another matrix, and I want to look up the Service Level from the reference table.

You are viewing 1 out of 8 answers, click here to view all answers.

Latest Questions