Error: Argument size mismatch
Overview
Creating a Velixo function which refers to more than one Excel array (using the # syntax) results in a #VALUE! error with the following message:
Text of Message
Argument size mismatch: all arguments containing more than one value are expected to be of the same size
Cause
When using multiple array references within a single function...
... Excel requires that each array be of the EXACT same size.
If the arrays are not of the same size, this Excel generates this error.
In the above example, there are 149 account codes but only 4 branch codes.
Workaround
When using arrays as cell references, it is usually necessary to only use one array reference within a function.
For example, here we are using a reference to the array of account codes in column C (but only to the individual branch code in row 6):
