=IF(ISNA(your formula),"",your formula)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"frank" wrote in message
...
is there a way to avoid getting the #N/A as a response
when I do a Lookup? i would simply rather return a blank.
|