Forum Discussion
Filter formula for looking up data in a table
Hi, I,m looking for a formula that can lookup and return results when I select the name and return the vehicles at the top eg - Andy Scooter Bicycle Car Bus Thanks for any help ...
=LET(arr,LAMBDA(x,CHOOSE(x,A2:A5,SEQUENCE(ROWS(B2:H5)))),
MAP(arr({1}),arr({2}),LAMBDA(a,b,TEXTJOIN(" ",,a,FILTER(B1:H1,CHOOSEROWS(B2:H5,b)="x")))))This should work if i correctly understand what you are looking for.