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
Kirill S. Palagin wrote:
Hello.
I am hitting the problem where I need to return value of cell with
VLOOKUP and if cell contains 0, result seems to be string,
which can
not be used in math formulas. When I refer directly to cell
(=Sale.D250) it correctly returns zero.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
