Hi

Post your existing formula and we may be able to help.
--
Regards

Roger Govier


"daidipya" wrote in message
oups.com...
I am using a Vlookup command and getting a #NA error, instead i want
the value 0. i know that there is a if(isna(vlookup....0) formulae but
i have three vlookup in the same cell so it is becoming next to
impossible to use that command . is there any way out.

daidipya