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

Answer 1 / 3
via55 Posted messages 14387 Registration date   Status Member Last intervention   2 755
 
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
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