9 Aug
2009
9 Aug
'09
08:08
Per Jessen wrote:
My lookup (in Sheet2)
=LOOKUP(A2;Sheet1.$A$2:$A$65536;Sheet1.$F$2:$F$65536)
I sent Nkoli a copy of my shreadsheet off-line, and he pointed out the LOOKUP does not do an exact match, whereas VLOOKUP can be made to do.
From the OO Help page: "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion."
Thanks Nkoli! /Per -- Per Jessen, Zürich (19.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org