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.
> -----Original Message----- > From: Terry [mailto:[EMAIL PROTECTED] > Sent: Friday, September 01, 2006 5:03 PM > To: [email protected] > 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: [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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
