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]
