Excel VLOOKUP Challenge: Can It Return 0 Instead of #N/A?

jaya444
For a particular dataset, I need to use the VLOOKUP function. I want to know if there is an option for the function to return 0 instead of #N/A.
jayshree15
Hi,

I have attached Excel shortcuts that I downloaded from Citi HR. Maybe it will help you.

Regards,
Jayshree
1 Attachment(s) [Login To View]

sriharsha
Hi Jaya, if a particular number (e.g., Employee code) is not in that sheet, from where do you want to get that data? It will show #N/A.
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