:?:For a particular data I need to use Vlookup function. I want to know that when the function returns #N/A is there an option that instead of this the value comes as zero?
From India, Bangalore
hi i have attached excel shortcuts... i have download it from citi hr only... may be it will help u... regards, jayshree
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: zip Excel Shortcut.zip (261.6 KB, 511 views)

hai jaya if perticular number exp(Employee code) is not in that sheet from where u want to get that data it will shows #N/A
From India, Visakhapatnam
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.