Last updated on by Raymond PENTIER
The CHOOSE function, yet easy to use, is used too little.
These functions are extensively described in tutorials, forums, blogs, online training. But we considered it relevant to bring them together in the same thematic sheet. https://www.cjoint.com/c/JHbbkuHnIFB
———————— INDEX —–>
———————— MATCH —–>
TO CHOOSE - This function is used to display a value according to an index number:
= CHOOSE (N °; val1; val2 ...)
The number must be between 1 and 254; it designates the value argument to select.
The value can be a cell reference, a formula, a text, a number (for a fraction, the whole part) ...
INDEX + MATCH
INDEX Vs EQUIV
This article appeared first on CCM