Excel VLOOKUP Returns Zero Values - Need Blanks Instead
I recently created a VLOOKUP that returned zeros instead of blank cells. Maybe this solution will work for you too.
My original VLOOKUP:
=VLOOKUP(A2,'Responded List'!C2:D27,2,FALSE)
A solution adding &"" to create the blank cell:
=VLOOKUP(A2,'Responded List'!C2:D27,2,FALSE)&""
Another solution using an IF statement:
=IF(VLOOKUP(A2,'Responded List'!C2:D27,2,FALSE)=0,"",(VLOOKUP(A2,'Responded List'!C2:D27,2,FALSE)))
Another solution using IFERROR as suggested by a commenter:
=IFERROR(IF(ISBLANK(VLOOKUP(A2,'Responded List'!C2:D27,2,FALSE)),"",VLOOKUP(A2,'Responded List'!C2:D27,2,FALSE)),"")
And, another solution that ⭐DOES NOT REQUIRE A FUNCTION⭐:
File _Options _Advanced _Uncheck "Show a Zero in Cells that Have Zero Value"
Download the updated file here:
https://www.dropbox.com/scl/fi/rqhvzk...
View Dawn's Excel Playlist: • Excelling at Microsoft Excel
Dawn Monroe Training
Microsoft Office Specialist Master
Wichita, KS, USA
https://dawnmonroetraining.com/
PLEASE SUBSCRIBE for more tips!
🔔 Subscribe for Updates 🔔
YouTube: / dawnmonroetraining
❤️ Connect on Social ❤️
LinkedIn: / dawnmonroetraining
Facebook: / dawnmonroe.training
Instagram: / dmonroetrain
💥 View Learning Opportunities💥
Calendar: https://learn.dawnmonroetraining.com/...
Website: https://dawnmonroetraining.com/
This video was recorded with Loom.
#microsoft #365 #excel #exceltips #lookup #vlookup #vlookupformula #vlookupinexcel #vlookupfunction