I tried that with a blank cell and got "Error:502". Yet it works on
your system?
Anthony Chilco wrote:
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
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]
