Hi guys,

I would like you to ask if you would be so kind and explain me why it is working like it is. I understand HOW it is working, but i don't understand WHY.

I dont understand the part where it is:

---------
Example
---------

=INDEX(MATCH(AGGREGATE(15,6,Range1/(Range2&Range3=A1&A2),1),Range1,0))

I know that it will return only results from range that are equal to A1&A2 but why i am using "/" this in that formula and brackets? It's probably easy math logic but i am still learning excel and i am hungry for knowledge.