Скачать или смотреть 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