And thinking about it, what would be the top of the top is if you can
use an array function or a range in any of the argument of the
function, i.e.

{=WA(IF(Z1:Z100="Blue",D1:D100,E1:E100),C1:C100)}

which would allow to substitute a value to another within the first
argument based on wether the column Z says Blue or not.

starts to look like a kid's christmas list. I am mostly curious about a
syntax that would accomodate everything

Thanks
Charles