My bad - I double-checked and found that original cell is empty. I can use it math formulas, but vlookup result generates error Err:502 when used in math expressions. This inconsistency is wrong, I think.
> -----Original Message----- > From: Terry [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 02, 2006 3:46 AM > To: [email protected] > Subject: Re: [users] Vlookup of empty cell > > I checked that with ISNUMBER on the cell containing the > VLOOKUP formula and got "TRUE". How do you reach the > conclusion that the returned value is not a number? > > 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. > > > >> -----Original Message----- > >> From: Terry [mailto:[EMAIL PROTECTED] > >> <snip> > >> 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. > 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]
