Hello Team,
Please excuse my ignorance.
I would like to know what the ampersand and the excliamation marks do or
what are they for?

INDEX(C8:C28,MATCH(D1&" "&MAX((B8:B28=D1)*(D8:D28)),B2:B8&" "&C2:C8,0))

Thank you and best regards

Max