We are using VLOOKUP formula also the result of VLOOKUP is input of another formula. If the result of VLOOKUP is in number, than there is no problem for next dependent formula. But when result of VLOOKUP is “#N/A” (being the corresponding value for VLOOKUP not availed) than the result of next formula also become “#N/A”. Whether it is possible to convert “#N/A” (if the corresponding value for VLOOKUP not availed) to “0” automatically.