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
Acknowledge(0)
Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
4From India, Mumbai
Acknowledge(0)Amend(0)
Hi, Go thru the attachment you will get the idea about how to use the formula Regards Gaurav Waikar
From India, Mumbai
Acknowledge(1)Amend(0)
From India, Mumbai
Acknowledge(1)Amend(0)
Dear Suresh, Pl. find the attached file . Pl explain me with more than five or six examples
From India, Jaipur
Acknowledge(1)
Amend(0)
From India, Jaipur
Acknowledge(1)Amend(0)
CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
EXCEL FORMULA.xls
10 ways to format Excel data.pdf