How do you replace Vlookup #NA errors with zero or blank cell
- Thread starter huyle2103
- Start date
arup1032
New member
- Joined
- Sep 7, 2015
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Age
- 35
- Location
- Bangladesh
- Excel Version(s)
- Excel 2013
1) Just copy all the cell.
2) Then click on your right button of mouse and select paste special from the menu. Then select values only. Or after copy just type alt+E+S+V to paste value.
3) Then type ctrl+h and right #N/A on "find what" and leave empty the "replace with". Then hit enter.
Your job will be done.
2) Then click on your right button of mouse and select paste special from the menu. Then select values only. Or after copy just type alt+E+S+V to paste value.
3) Then type ctrl+h and right #N/A on "find what" and leave empty the "replace with". Then hit enter.
Your job will be done.
navic
New member
- Joined
- Aug 27, 2013
- Messages
- 901
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013
For Excel 2003
Code:
=IF(ISERROR(VLOOKUP-formula),"",VLOOKUP-formula)For Excel 2007 and later
Code:
=IFERROR(VLOOKUP-formula,"")Hercules1946
New member
- Joined
- Mar 22, 2013
- Messages
- 794
- Reaction score
- 0
- Points
- 0
- Location
- York, England
- Excel Version(s)
- 2010
Would you need to repeat this every time N/A arises in a different location?