INDEX MATCH formula for multiple criteria

I have looked all over and not quite found the answer to my question. I have tried a lot of INDEX and MATCH posts which offer COUNTIF or an absolute, like 3 which is not what I’m after.

I have a sheet with some workflow information on Sheet1 and I’m trying to create a summary dashboard that copies over only relevant data onto Sheet2.

Table below shows original sheet



















Team Requested date Not needed Not needed Status Completed date Request Summary
ABC 6-May x y Completed 7-May Cat Needs toys
ABC 2-May x y Unallocated   Dog Needs bones
DEF 7-May x y In progress   Monkey Needs bananas
DEF 1-May x y in progress   Giraffe Would like someone to check his neck
GHI 30-Apr x y Completed 15-May Lion Hungry
GHI 17-May x y In progress   Ibis Thirsty
JKL 17-Apr x y Completed 2-Jun Peacock Bored
JKL 6-May x y Unallocated   Koala Itchy

What I would like my dashboard to show is the request name, the summary, the team and the completed date. BUT only where status = completed AND within a specified date range

Desired output









Request Summary Team Completed date
Cat Needs toys ABC 7-May
Lion Hungry ABC 11-May

Thanks in advance.

By: Fiona

29 thoughts on “INDEX MATCH formula for multiple criteria

  1. kyrie 5

    I wish to show my thanks to you just for rescuing me from such a incident. Just after researching through the internet and meeting principles that were not beneficial, I thought my life was over. Being alive without the presence of approaches to the issues you’ve fixed all through this article is a serious case, as well as the ones which might have badly damaged my entire career if I had not come across the website. Your actual knowledge and kindness in dealing with all the pieces was tremendous. I am not sure what I would’ve done if I had not encountered such a stuff like this. It’s possible to at this time relish my future. Thanks for your time so much for this impressive and sensible guide. I won’t hesitate to propose your web sites to any person who should receive guidelines on this subject matter.

  2. ig

    Hi there to every body, it’s my first visit of this website; this blog carries remarkable and really excellent material for visitors.

  3. yeezy boost 350

    Thanks for your entire hard work on this site. My niece delights in getting into internet research and it’s obvious why. Almost all learn all of the lively form you give vital information through your web site and therefore boost response from the others on this subject then our favorite simple princess is actually becoming educated a whole lot. Enjoy the rest of the year. You’re conducting a splendid job.

  4. fila shoes

    A lot of thanks for all your effort on this web page. My daughter delights in going through investigation and it’s really obvious why. All of us know all relating to the powerful mode you render very useful items via the web site and as well as foster participation from others on this issue so our favorite girl is certainly becoming educated a lot of things. Take advantage of the remaining portion of the year. You are carrying out a tremendous job.

  5. yeezy 500

    I really wanted to develop a quick note to thank you for the fantastic ideas you are showing on this site. My prolonged internet lookup has finally been honored with really good facts and techniques to go over with my friends and family. I ‘d assert that many of us website visitors actually are rather fortunate to exist in a fine community with so many lovely professionals with very helpful methods. I feel somewhat fortunate to have used your entire website and look forward to many more fun moments reading here. Thanks a lot once again for everything.

  6. moncler

    Thank you a lot for providing individuals with an exceptionally memorable possiblity to read critical reviews from this site. It’s usually very fantastic and jam-packed with a lot of fun for me personally and my office co-workers to search your blog no less than 3 times a week to see the fresh stuff you have. And definitely, I am just certainly astounded with all the fantastic guidelines you give. Certain 4 ideas on this page are clearly the most suitable I have ever had.

  7. golden goose sneakers

    I actually wanted to post a simple word to appreciate you for all the amazing suggestions you are giving at this website. My rather long internet look up has at the end been paid with reasonable details to write about with my classmates and friends. I ‘d believe that we visitors are extremely fortunate to be in a notable network with very many special people with very beneficial tactics. I feel really blessed to have discovered the website page and look forward to really more brilliant times reading here. Thanks a lot once more for a lot of things.

  8. jordan store

    I just wanted to develop a simple remark so as to say thanks to you for all the remarkable recommendations you are sharing on this website. My considerable internet search has at the end been paid with wonderful content to talk about with my friends and classmates. I would admit that many of us site visitors actually are extremely blessed to be in a wonderful website with very many brilliant people with good advice. I feel very grateful to have come across your entire web site and look forward to really more fun times reading here. Thanks a lot again for everything.

  9. hermes

    A lot of thanks for your own efforts on this website. My mom delights in doing internet research and it’s simple to grasp why. Most of us know all about the powerful method you make priceless things on your blog and therefore foster response from the others on the situation plus our princess has always been being taught a whole lot. Take pleasure in the remaining portion of the year. You are performing a dazzling job.

  10. louboutin outlet

    I together with my pals were found to be going through the best key points on your website and the sudden developed a horrible feeling I never expressed respect to the web site owner for those techniques. Most of the young boys ended up as a result thrilled to read all of them and already have in reality been taking pleasure in them. Thank you for actually being so kind as well as for picking out such superb issues most people are really needing to know about. Our sincere apologies for not saying thanks to earlier.

  11. vans outlet

    Thanks for your whole work on this blog. Debby enjoys managing investigations and it is easy to understand why. All of us learn all regarding the powerful mode you provide useful strategies on the web site and as well as improve contribution from people on this article then our favorite simple princess has always been being taught so much. Have fun with the remaining portion of the new year. Your doing a tremendous job.

  12. pg 1

    I in addition to my guys have been checking out the excellent advice on the blog while all of a sudden got a horrible suspicion I had not expressed respect to the site owner for those secrets. Those people are actually so passionate to read through them and now have quite simply been taking pleasure in them. Appreciate your being really thoughtful and then for utilizing this kind of beneficial areas most people are really needing to learn about. My sincere apologies for not expressing gratitude to you sooner.

  13. supreme hoodie

    I have to convey my affection for your kindness giving support to men and women that require assistance with in this theme. Your personal commitment to passing the message all over had been rather advantageous and have truly permitted those like me to realize their ambitions. Your own valuable hints and tips entails a great deal to me and still more to my office colleagues. Best wishes; from all of us.

  14. kd 10

    I precisely wanted to appreciate you all over again. I am not sure the things that I would have accomplished without those solutions contributed by you directly on my area. It actually was the frightening problem for me personally, but witnessing the very specialized fashion you handled the issue took me to cry with delight. Now i am grateful for your guidance and as well , have high hopes you comprehend what an amazing job you happen to be accomplishing educating many others by way of a blog. I am certain you haven’t met any of us.

  15. longchamp

    I needed to write you that little word to finally say thanks a lot yet again just for the great techniques you have provided above. It’s quite incredibly generous with you to present openly all most people would have supplied for an e book in making some profit for themselves, mostly now that you could possibly have tried it in the event you considered necessary. The points in addition served to be a fantastic way to understand that someone else have similar dreams much like my own to figure out a great deal more related to this problem. I know there are numerous more pleasurable sessions in the future for individuals that scan through your site.

  16. adidas zx flux

    I simply wished to say thanks all over again. I do not know the things I would’ve followed in the absence of the actual methods shown by you over such situation. Certainly was a real alarming issue for me personally, nevertheless coming across this specialized approach you treated it took me to leap over delight. Now i am happy for the help and sincerely hope you know what a powerful job that you are accomplishing instructing others by way of your web site. I’m certain you’ve never come across all of us.

  17. supreme

    I definitely wanted to send a quick word to express gratitude to you for all the awesome tips and hints you are placing on this site. My time-consuming internet look up has at the end been honored with beneficial details to exchange with my partners. I would tell you that many of us visitors are definitely endowed to be in a notable site with very many outstanding people with interesting methods. I feel very much grateful to have discovered your entire webpage and look forward to plenty of more enjoyable times reading here. Thank you once more for everything.

  18. kobe shoes

    I wish to convey my respect for your kind-heartedness for folks that actually need help on the study. Your real dedication to getting the solution throughout appears to be certainly significant and have really made individuals just like me to reach their aims. Your new helpful hints and tips means a lot a person like me and a whole lot more to my office workers. Best wishes; from all of us.

  19. supreme shirt

    I want to express my thanks to you for bailing me out of this type of situation. Right after browsing throughout the internet and coming across tips which were not productive, I believed my entire life was gone. Living without the presence of answers to the difficulties you’ve resolved all through this site is a critical case, and ones which could have in a negative way affected my entire career if I hadn’t encountered the blog. Your primary understanding and kindness in maneuvering the whole lot was useful. I’m not sure what I would have done if I hadn’t come upon such a stuff like this. I can at this point look ahead to my future. Thanks for your time very much for your professional and sensible guide. I won’t think twice to refer the blog to anyone who would like care about this topic.

  20. calvin klein

    There are certainly lots of details like that to take into consideration. That could be a great level to carry up. I provide the thoughts above as normal inspiration but clearly there are questions like the one you convey up where the most important factor will be working in honest good faith. I don?t know if finest practices have emerged around issues like that, however I am certain that your job is clearly identified as a good game. Each boys and girls really feel the influence of only a moment抯 pleasure, for the rest of their lives.

  21. hermes

    This is the suitable weblog for anyone who needs to search out out about this topic. You notice a lot its virtually laborious to argue with you (not that I actually would need匟aHa). You positively put a brand new spin on a subject thats been written about for years. Great stuff, just great!

  22. goyard handbags

    Once I originally commented I clicked the -Notify me when new comments are added- checkbox and now each time a remark is added I get four emails with the identical comment. Is there any means you’ll be able to take away me from that service? Thanks!

  23. lebron 16 shoes

    Nice post. I be taught something more difficult on different blogs everyday. It can all the time be stimulating to learn content material from different writers and apply a bit of one thing from their store. I抎 want to make use of some with the content on my weblog whether you don抰 mind. Natually I抣l give you a link in your internet blog. Thanks for sharing.

  24. jordans

    Hiya! I just want to give an enormous thumbs up for the good information you could have right here on this post. I will be coming again to your blog for extra soon.

Comments are closed.