Hi. It's the sort of formula that I at least try to avoid, but you
could just preface your VLOOKUP formulas with an IF statement:
IF(VLOOKUP(<etc>)="";0;VLOOKUP(<etc))
Kirill S. Palagin wrote:
My bad - I double-checked and found that original cell is empty.
I can use it math formulas, but vlookup result generates error Err:502
when used in math expressions.
This inconsistency is wrong, I think.
<snip>
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]
