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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks