I'm using VLOOKUP to search for results in another worksheet. What I need is 0 returned if the search fails. Currently I'm getting #N/A and that's causing my other formulas to fail.
Any suggestions???
TIA
I'm using VLOOKUP to search for results in another worksheet. What I need is 0 returned if the search fails. Currently I'm getting #N/A and that's causing my other formulas to fail.
Any suggestions???
TIA
Last edited by Tanasi; 03-27-2009 at 12:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks