On 07/21/2010 06:45 PM, listofx wrote: > On δΈ‰, 2010-07-21 at 17:52 -0700, NoOp wrote: >> On 07/21/2010 05:50 PM, listofx wrote: >> > has been solved. >> >> Please advise how. This could help others that have the same issue. >> > > vlookup has a disturbing parameter, the fourth parameter, which is a > optional parameter. Indeed, there are good instructions in help > document. But I remember, I always made the same mistake every time I > use calc occasionally. > In my case, I shall always assign sort order value 0 (which is not the > default value) since names in the first column have not been sorted. > >> >> VLOOKUP(search criterion, array, index, sort order). >> >> SortOrder is an optional parameter that indicates whether the >> first column in the array is sorted in ascending order.
Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
