LinkBack URL
About LinkBacks
When I do a VLOOKUP and it cannot find the info than I always get #N/A. Is there a way that I simply get an empty result or 0 value?
When I do a VLOOKUP and it cannot find the info than I always get #N/A. Is there a way that I simply get an empty result or 0 value?
Last edited by pansovic; 10-15-2011 at 06:08 PM.
You can use the VLOOKUP and ISERROR formulas: =IF(ISERROR(VLOOKUP(A1,S20:U30,3,FALSE)),0,VLOOKUP(A1,S20:U30,3,FALSE))
Change the vlookup for your own criteria. The 0 can be replaced with "" for a blank result.
You can first test is there a value with MATCH function, and if is you can use VLOOKUP.
That's slightly better then rambo1 approach because it don't need to use VLOOKUP function twice.
In most cases above approach will work fine.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks