The "let" function may be of interest to those wanting to excel more programmatically. There's also lambda that is interesting for the more modern excel use cases.
=Let(table,$C$17:$S$24,
rowName,A6,
colName,C6,
headerRow,$C$15:$S$15,
headerCol,$A$17:$A$24,
rowIndex,MATCH(rowName,headerCol,0),
colIndex,MATCH(colName,headerRow,0),
index(table,rowIndex,colIndex)
)
or even
=LAMBDA(table,rowNames,colNames,rowToFind,colToFind,
LET(
rowIndex,MATCH(rowToFind,rowNames,0),
colIndex,MATCH(colToFind,colNames,0),
INDEX(table,rowIndex,colIndex)
)
(Also alt+enter to input the newlines)
You can also put the lambda function inside the let function, which is handy.
Also, almost everyone should be using tables instead of ranges. The references are missing a few features, but it makes formulas a brazillion times more readable.