Hello,
If the Vlookup produces a "N\A error how do I write the vlookup not to show "N\A"?
=VLOOKUP(A14,$A$2:$B$9,2,FALSE)
Hello,
If the Vlookup produces a "N\A error how do I write the vlookup not to show "N\A"?
=VLOOKUP(A14,$A$2:$B$9,2,FALSE)
Perhaps=IFERROR(VLOOKUP(A14,$A$2:$B$9,2,FALSE),"")
Sweet!!! Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks