Forum Discussion
Having a problem with Index Match formula. Keeps giving me a value error
Hello Community - I have an urgent business meeting and need to get this error fixed. My formula works perfectly if I just use two index match statements. When I add a third, it gives me a ...
I recommend this formula:
=CHOOSE(MATCH(K655,{"PSU Rev A","PSU Rev B","PSE1"},0),
INDEX(Rev_A[Qty To Return],
MATCH([@[Ship To Customer]],Rev_A[Ship To Customer],0)),
INDEX(Rev_B[Qty to Return],
MATCH([@[Ship To Customer]],Rev_B[Ship To Customer],0)),
INDEX(PSE_1[Qty to Return],
MATCH([@[Ship To Customer]],PSE_1[Ship To Customer],0)))The foregoing formula is easier to understand and faster to calculate.