View original (French)

Display multiple values Index(Match)

Solved
Quentin! Posted messages 3 Status Member -  
Quentin! Posted messages 3 Status Member -
Hello everyone,

I am reaching out to you because I have been trying for several days to display the event name associated with a date. I have made some progress, but when multiple events happen on the same date, the Index Match function only returns the first value!
I am attaching my document in hopes that an expert will be able to find the solution to my problem:
http://www.cjoint.com/c/FGDiqq5eKNW

Thank you in advance!

3 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Good evening Quentin

    I haven't looked at the document you found, but here is a possibility using a matrix formula:
    https://mon-partage.fr/f/Cj1mX8ke/

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    3
    1. Quentin! Posted messages 3 Status Member
       
      Hello Via,

      Thank you very much for this response, it seems to be working perfectly.

      Thank you for your help :)

      Quentin
      0