Re:Show HN: Frockly – A visual editor for understanding comp...
by Cordiali on Wednesday December 31, 2025 @11:24PM
(#46451272)
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.
=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,
)($C$17:$S$24,$A$17:$A$24,$C$15:$S$15,A6,C6)(Also alt+enter to input the newlines)