Many times when I'm using V Look up. If there is no data in the data base that I'm using to grab data from it shows a ZERO "0". Anyway to make it show blank? I attached sample. Thanks
Many times when I'm using V Look up. If there is no data in the data base that I'm using to grab data from it shows a ZERO "0". Anyway to make it show blank? I attached sample. Thanks
Try this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This formula works for the example I provided. But the reason I provided the example is because the actual data I'm having the issue with I can't put online. So when I worked that formula into my real data it actually made all the cells go blank (but no error) so it does seem like it's working correctly just not with what I want.
The only main difference is I'm looking up letters & in the example I posted I used #'s. Does that matter? Thanks
It is your responsibility to provide accurate data.
Use this one
Formula:Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
Last edited by AlKey; 04-06-2017 at 04:17 PM.
I understand about being my responsibility on providing accurate data. I've done the same practice many times before and I always am able to figure out how to make it worked. This formula just more complex. I apologize for the time wasted. I did get it to work thanks to your 2nd formula. I greatly appreciate the time you spent and quick response as well. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks