Vlookup Formula Help - Xls Download

friends we use vlookup formula in excel but if the case is not match it shows #N/A in cell i want it display 0. how it will possible please suggest me.

I think you can add a column and write this formula -
if(cell name where you found #N/A ="#N/A",0,"")
and after that all #N/A will be 0 and you can select all columns no and copy after that paste in same column as pastte special option .
I think it can help you if you have any query please call me on my mobile no:- +91-8010272848
Thanks & regards
Sandeep Kumar Dwivedi

Hi Sandeep,
Use formula like mentioned under u will get the expected results,
=IF(ISNA(VLOOKUP(C2,A2:B5,2,FALSE)=TRUE),"0",VLOOK UP(C2,A2:B5,2,FALSE))
Regards,
Gaurav Waikar

Hi,
Go thru the attachment you will get the idea about how to use the formula
Regards
Gaurav Waikar

Dear Suresh,
Pl. find the attached file .
Pl explain me with more than five or six examples

Dear Mr. Gir raj,
Please find the attached file & I sure you will get your answer.
Thanks & Regards
Sandeep Kumar Dwivedi