Hello Colin,

I have explained in my first reply to your answer what I have tried to do. Basically my question was why I get an error on that formula and your answer was great (the "dereferenced" description worths the money) and I really appreciate it (thank you once again)

You are right that the formula results from K2 and L2 match, but they differ on the FALSE condition of the IF function (one has the array {99,99,99} and the other one {0,0,0}. This is my mistake when building the formulas...
So it seems to me that the N function does not return the values from C2:E2, but rather the value in C2.

Anyway thank you for your details, my "direct" knowledge of INDIRECT function moved a step further

Andrei