I have an index/match formula in a cell, and when it doesn't find a match it defaults to the first cell in the array. How can I make it return a blank or a zero?
I have an index/match formula in a cell, and when it doesn't find a match it defaults to the first cell in the array. How can I make it return a blank or a zero?
that is a strange index/match, usually if it doesn't find something it returns #N/A, if it finds something in the match section but not the index part it'll return a 0. if you want it to return a blank instead of #N/A then put IFERROR(your (index/match formula),"")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional)
(also, please show us your formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks