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? > > > > Thanks a lot. > > WBR, > > K. Palagin. > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] For > > additional commands, e-mail: [EMAIL PROTECTED] > > > > > 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]
