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 ...
Same as previous question answer.
=TEXTJOIN(", ",1,FILTER(B1:J1,FILTER(B2:J6,A2:A6=O1)="x"))
=BYROW(A2:J6,LAMBDA(r,TEXTJOIN(", ",1,TAKE(r,,1),FILTER(B1:J1,DROP(r,,1)="x"))))