Kirill S. Palagin wrote:
In my case cell is not empty - it contains the value of zero, I can use
that cell in all math operations, but result of vlookup is not a number.
I've just been trying various possibilities with this (using OOo 2.0.3)
and in every case, lookup returns whatever is in the target cell. IMO
this is what I would expect to happen. I may want lookup to return
empty, or with whatever text is in the target cell, or a number.
I tried =VALUE(VLOOKUP(...)) where the lookup returns empty, and I also
get Err:502. VALUE() doesn't like empty/null. So, what is the type of an
empty cell returned by a lookup function? Why isn't it interpretted as
zero or "" depending on context as it is for a direct cell reference?
In the meantime, I think the solution is to split any formula that
contains a problematic lookup so that the lookup is done in a separate
cell, then reference that cell in the formula.
Ross
-----Original Message-----
From: Terry [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 5:03 PM
To: users@openoffice.org
Subject: Re: [users] Vlookup of empty cell
I've been trying to think of a reason for the difference.
Entering zeros in the range looked up would work. I'm not
sure, if a cell is blank, that the result from VLOOKUP is wrong.
Kirill S. Palagin wrote:
Yep, that did the trick.
Thanks a lot.
WBR,
K. Palagin.
-----Original Message-----
From: Terry [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 31, 2006 2:20 PM
To: users@openoffice.org
Subject: Re: [users] Vlookup of empty cell
Use INDEX combined with MATCH as in:
=INDEX($B1:$B5;MATCH("alpha";$A$1:$A$5;0))
MATCH gets the row number in the reference range.
INDEX gets the value in the lookup range in that row.
Kirill S. Palagin wrote:
Hello.
I am hitting the problem where I need to return value of
cell with
VLOOKUP and if cell contains 0, result seems to be string,
which can
not be used in math formulas. When I refer directly to cell
(=Sale.D250) it correctly returns zero.
Problem described clearly in last 3 comments to
http://www.openoffice.org/issues/show_bug.cgi?id=8088
How do people work around that?
Send instant messages to your online friends
http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]