On 10/10/2010 01:12, Andreas Säger wrote: ....
VLOOKUP(v;range;2) with modified column order, LOOKUP(v;search;return) or INDEX(return;MATCH(v;search)). It's always the same spreadsheet lookup where the search vector needs to be sorted. Otherwise you get wrong results.
That's not quite what the help file suggests; at least for vlookup() you can specify whether the list is sorted or not - if sorted, it returns an appropriately close match, if unsorted, you get an exact match or an error.
-- Mike Scott Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
