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
From India, Delhi
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
7if(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
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
From India, Mumbai
Hi, Go thru the attachment you will get the idea about how to use the formula Regards Gaurav Waikar
From India, Mumbai
From India, Mumbai
Dear Suresh, Pl. find the attached file . Pl explain me with more than five or six examples
From India, Jaipur
From India, Jaipur
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.
Vlookup example.xls
The-Winning-for mula.pps