With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, July 13, 2012
yogi_Look At Implications Of LookUp Range Sorted In Asc Order In Use With The VLookup Function
Well, my take is ... NO ... not really since it has not been truly sorted in Asc order, I have chosen to call the SORTing performed by the SORT function as SweetenedSort (I could have also called it by some other choice words ... but let us play nice) as I discuss it in the following. That is why in working with the LookUp range SweetSORTed in Asc order I still have to use the 4th argument of 0 because the Lookup range SweetSORTed in Asc order is not truly sorted in Asc order.