2 ms·
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 cas
by knollimar 10mo ago
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)
)
)($C$17:$S$24,$A$17:$A$24,$C$15:$S$15,A6,C6)
(Also alt+enter to input the newlines)
- Cordiali 10mo agoYou 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.