Among the various ways to return multiple values in a function that you covered in your video, my favorite is array because it is the only way that allows freedom in what the function can return.  All the other ways -- custom data type, class type, collection -- are pre-configurations that the user must adhere too.  For instance, if a custon type is set up to contain name, address, city, etc., then the function must return those.  If the user needs to return something different, say, title, suffix, etc., the data type must be rewritten, which will affect all the functions that use it.  In many situations, you just don't want to "locked into" that type of setup.  Hence, a variant array that doesn't have a pre-configured type seems to be the most flexible.  Any function that returns an array can declare it as whatever size and dimension required by the user.  The SAME function, with the use of an If...Then condition, can declare it as a one-dimensional numeric array or a multi-dimensional string array, depending on what the user needs.  The only downside is that an array, once declared, can only store one data type, i.e. all numeric, all string, etc.