Brad Rogers wrote:
On Sat, 09 Oct 2010 15:05:48 +0200
Andreas Säger <[email protected]> wrote:
Hello Andreas,
For the given order of columns and _ascending ordered_ lookup vector
in B:
{snip}
Thanks for the tips, Andreas. I've actually achieved what I wanted
using vlookup, as per Mike Scott's advice.
Good to see that there's more than one way to solve the problem, though.
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
