sandeepsmi
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.
From India, Delhi
sandeepdwivedi.86@gmail.c
7

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

From India, Delhi
gaurav.waikar
3

Hi Sandeep, Use formula like mentioned under u will get the expected results, =IF(ISNA(VLOOKUP(C2,A2:B5,2,FALSE)=TRUE),"0",VLOOKUP(C2,A2:B5,2,FALSE)) Regards, Gaurav Waikar
From India, Mumbai
gaurav.waikar
3

Hi, Go thru the attachment you will get the idea about how to use the formula Regards Gaurav Waikar
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls VLOOKUP.xls (17.0 KB, 1775 views)

Oajat Girraj
1

Dear Suresh, Pl. find the attached file . Pl explain me with more than five or six examples
From India, Jaipur
Attached Files (Download Requires Membership)
File Type: xls VLOOKUP_Example.xls (26.0 KB, 1363 views)

sandeepdwivedi.86@gmail.c
7

Dear Mr. Gir raj, Please find the attached file & I sure you will get your answer. Thanks & Regards Sandeep Kumar Dwivedi
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Vlookup Formula Use.xls (39.0 KB, 1678 views)

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.