Notes: 1  Gain on disposal of investments and interest income are not considered as revenue because they are not earned from the principal business activity of ABC PLC, i.e. selling stationery goods.
To assign values to the various positions in an array, you do it in the normal way: aryNums[0] = 10; Here, a value of 10 is being assigned to position 0 in the array called aryNums. Again, the square brackets are used to refer to each position.
Array of Values. We can ask the VLOOKUP function to return an array of values by enclosing the third argument in curly braces {}. This causes the VLOOKUP function to actually return an array that contains multiple elements.