On Sun, 10 Oct 2010 15:08:10 +0200 Andreas Säger <[email protected]> wrote:
Hello Andreas,
> From Brad's initial request I was unsure what what he actually wants.
It probably wasn't very clear, I agree.
> Row1 Cat 2
> Row2 Dog 4
> Row3 Mouse 3
> In which instance you'd like to get the lowest value?
Yes, the lowest numeric value was the search criterion, achieved using
MIN, to get, in the above example, the number two. Based on that, I
wanted the another cell to contain the creature associated with that
value. In this case, cat.
> Spreadsheet lookups can not match more than one position. If there
> happens to be another animal with 2 points below the Cat, you will see
> the Cat only.
Yes, I'm now aware of that, but for my purposes, that isn't an issue;
First matching object will suffice.
Once again guys, thanks very much for all your assistance, it's given me
a much better understanding of Calc an its workings.
--
Regards _
/ ) "The blindingly obvious is
/ _)rad never immediately apparent"
Go away, come back, go away, come back
Leave Me Alone (I'm Lonely) - P!nk
signature.asc
Description: PGP signature
