That is even better - modifications to formulas are so much easier! Thanks a lot! WBR, K. Palagin.
> -----Original Message----- > From: Anthony Chilco [mailto:[EMAIL PROTECTED] > Sent: Friday, September 01, 2006 6:25 PM > To: [email protected] > Subject: Re: [users] Vlookup of empty cell > > > Hi Krill, > Whenever I'm looking for numeric returns I enclose the > function with 'Value(vlookup(....))'. Any alpha string > returns will evaluate to zero. > Often, imported data will be interpreted as strings, even > though it contains only numerals. The value function will > convert these strings to the proper numeric value. > tc > > > >>> > >>> > >>> 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. > > > > --------------------------------------------------------------------- > 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]
