Excel VLOOKUP Help: How Can I Replace #N/A with 0 for Case Mismatches?

sandeepsmi

Friends, we use the VLOOKUP formula in Excel. However, if the case does not match, it shows #N/A in the cell. I want it to display 0. How can this be achieved? Please suggest to me.

gaurav.waikar

Use the formula as mentioned below, and you will get the expected results:

=IF(ISNA(VLOOKUP(C2, A2:B5, 2, FALSE)=TRUE), "0", VLOOKUP(C2, A2:B5, 2, FALSE))

Regards,
Gaurav Waikar

gaurav.waikar

Hi, please go through the attachment to understand how to use the formula.

Regards,
Gaurav Waikar

1 Attachment(s) [Login To View]

Oajat Girraj

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

Regards,
[username]

1 Attachment(s) [Login To View]

sandeepdwivedi.86@gmail.c

Please find the attached file, and I am sure you will get your answer.

Thanks and Regards,
Sandeep Kumar Dwivedi

1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute