Lookup function returning 0 instead of blank? | Troubleshooting Excel

Is your Excel lookup function returning a 0 when your lookup table clearly has a blank cell - and that's what you want displayed? How frustrating! Learn two methods to get that blank cell you're looking for - without adding extra helper columns, fussing around with cell formatting, or modifying your lookup table.

Contents of this Video -
0:00 Introduction
0:30 Disclaimer
0:44 Option 1
0:51 What is an empty string?
1:22 What does the ampersand do?
1:35 What does appending an empty string do?
2:41 When to use Option 1?
2:49 Option 2
2:54 How does TRIM work?
3:54 How does TRIM affect your lookup result?
4:49 When to use Option 2?
5:06 Did this help you solve your data problem?
5:12 Reach out

If this is something you want more help with, or you just want to follow me to find out more, you can find me at:
https://BlouDesigns.com - learn more about my company and schedule a Zoom chat
  / barbara-olsafsky   - follow and/or DM me for more on SOPs, Data Strategy (including working with data in Excel), and aligning your efforts with your goals

Subscribe to this channel:    / @bloudesigns  


Behind the scenes:
Video Editing with Techsmith's Camtasia: https://techsmith.z6rjha.net/YgjBNJ

Video Recording with (free) OBS Studio:
https://obsproject.com/

Audio tweaking with (free) Audacity:
https://www.audacityteam.org/

Note: This description contains affiliate links, which means that at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!