If there's a possibility of having empty cells, you have to add an
'iserror' test (or similar function) as well. It can get pretty messy
when dealing with unknown data sources.
tc
Terry wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
