Forum Discussion
Solved
Lookup Formula with multiple column
Hi There, I am trying to return data in a particular column but the lookup value could be in any of a number of columns and I am not sure the best way to pull this in. I have shown a snip with an exa...
I liked the way you dealt directly with the 2D totals array. MMULT works well for the OR condition.
I have used your workbook for a couple more dynamic array formulas but they are probably moving even further from the OP's comfort zone!
= MAP(CL, LAMBDA(CL₁, LET(
ORλ, LAMBDA(x, OR(x)),
found?, BYROW(totalling=CL₁, ORλ),
FILTER(rowNo, found?, "")
)))or with insider beta
= MAP(CL, LAMBDA(CL₁, LET(
found?, BYROW(totalling=CL₁, OR),
FILTER(rowNo, found?, "")
)))
Thanks for the demonstration of TOCOL function! Still getting myself familiar with MS365 here.