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

Max,

The ampersand "&" is used to concatenate two values.
e.g. If cell A1 has the text "Hello" and cell B1 has the text "World"
a formula in cell C1 reading "=A1&B1" would result in the text "HelloWorld"
(note no space between the words)
A formula in cell C2 reading "=A1&" "&B1" would result in the text "Hello
World" (Now you have a space between the words)
Any text needs to be enclose din quotation marks. In this example he space
was enclosed in quotation marks
A formula in cell C3 reading "=A1&" world" would result in the text "Hello
World"

Hope this helps.

Sean

"Maxwell" wrote in message
...
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