Of course. The original inquiry (see the subject heading) referred to
an empty cell. Hence my suggestion of index/match.
Vlookup also seems to return a numerical result if a zero is entered in
the looked up cell.
It seems that the problem arises from numbers entered as text.
Anthony Chilco wrote:
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]
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]
