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:

Dawn Monroe Training
Microsoft Office Specialist Master
Wichita, KS, USA

PLEASE SUBSCRIBE for more tips!

🔔 Subscribe for Updates 🔔

❤️ Connect on Social ❤️

💥 View Learning Opportunities💥

This video was recorded with Loom.

#microsoft #365 #excel #exceltips #lookup #vlookup #vlookupformula #vlookupinexcel #vlookupfunction