9 Aug
2009
9 Aug
'09
14:52
Per Jessen wrote:
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.
she =P
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
You're welcome! Nkoli -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org