Hello Everyone,
I have an issue with a multiple criteria Index/Match formula. I've attached an example. As you can see, I'm getting an "#N/A" return and I'm not sure why. If you make the formula single criteria (using either set of criteria) it seems to work fine.
If someone could explain what is causing the error, I'd really appreciate it.
Thanks!IndexMatchIssue.xlsx
Your formula is written as an array formula. Try confirming it as an array with Ctrl-Shift-Enter.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
As ConneXionLost has said, committing the formula with Ctrl-Shift-Enter will work. However, it will be horrendously slow given the whole column references. I would recommend defining some Dynamic Named Ranges for the columns.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I can't believe I kept forgetting to Ctrl+Shift+Enter on that. I'm a moron. haha
Thanks for your help, CL and TMS!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks