Forum Discussion
Solved
Combine XMATCH with MAP, BYROW, SCAN or any other LAMBDA helper.
Hi, The goal here is to find the column in area C5:I16 for each row, based on the value in E19:E30. My idea was to use some of the new LAMBDA helpers, combined with XMATCH. Use that result and wind...
Is this the sort of thing you are looking for?
If so, possible formulas might include
= BYROW(data, LAMBDA(row, XLOOKUP(MIN(row), row, År) ))or
= MAP(Lavest#, SEQUENCE(12), LAMBDA(lav,m, XLOOKUP(lav, CHOOSEROWS(data,m), År)) )
Thank you for sharing this workbook. Lots of options with these functions:
=BYROW(C5:I16,LAMBDA(row,TAKE(DROP(B4:I4,,XMATCH(0,row,1)),,1)))