Index / Match Formula?

7.81K viewsFormulas and Functions
0

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?

0

Cool! That was easy.

One thing I did to make this formula a bit more readable for my novice eyes was to change the first argument:

[i:1mksz8ew]Original formula:[/i:1mksz8ew]
Service Level = [b:1mksz8ew]Stock_to_Sales::Ratio[/b:1mksz8ew]
using Ratio as Stock_to_Sales::Ratio,
Velocity as Stock_to_Sales::Velocity

[i:1mksz8ew]Revised formula:[/i:1mksz8ew]
Service Level = [b:1mksz8ew]Stock_to_Sales::Service Level [/b:1mksz8ew]
using Ratio as Stock_to_Sales::Ratio,
Velocity as Stock_to_Sales::Velocity

The result is the same, but this more clearly shows me how the USE AS function works.

Thanks again!

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

Latest Questions