LinkBack URL
About LinkBacks
I need my vlookup to return a zero if it doesn't find an entry in the lookup table.
My formula is =VLOOKUP(A272,'Actually Shipped - Pivot'!$A$1:$B$10000,2,FALSE)
What do I need to add?
I need my vlookup to return a zero if it doesn't find an entry in the lookup table.
My formula is =VLOOKUP(A272,'Actually Shipped - Pivot'!$A$1:$B$10000,2,FALSE)
What do I need to add?
make it like this...
=IFERROR(VLOOKUP(A272,'Actually Shipped - Pivot'!$A$1:$B$10000,2,FALSE),0)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you so much!
Sure, and if that solves your issue please take a moment and mark the post as solved using the thread tools dropdown at the top of the post.
And if you are so inclined clicking on the "add reputation" at the bottom of the post is how we advance on this forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks