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: [email protected]
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]
