Can IF ISNA be used to return a blank when INDEX MATCH errors out?
The subject says it all. "Can IF ISNA be used to return a blank cell when INDEX MATCH errors out?"
I use a lot of INDEX MATCH formulas at work and the sheets don't look so good with all the "errored out" cells before data is entered, or if a formula is dragged down much further than we use it at the moment.
Any help here?
Cheers.
Last edited by myshadeofglory; 10-21-2011 at 01:41 PM.
Wrap it in an IFERROR(your index/match),"")
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Didn't even know about that function. Thank you! Problem solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks