Forum Discussion
Re: Help with with Lookups etc.
Here are 2 options:
=FILTER(ROLES!A1:L90,MMULT(--("Role A"=ROLES!C1:K90),SEQUENCE(COLUMNS(ROLES!C1:K90),1,1,0)),"none")or
=FILTER(ROLES!A1:L90,BYROW(ROLES!C1:K90,LAMBDA(r,ISNUMBER(XMATCH("Role B",r)))),"none")in each case the ranges and roles can be updated as needed.
instead of different tabs for each Role you could have 1 tab and have a drop down on that sheet for which role to show.
2 Replies
Hi,
Both of these formulas achieve what I want in terms of isolating the roles I need. I'll also try and use only one tab as you suggest
Thanks very much!
Hi,
Both of these do what I need in terms of isolating the "Band Members". I'll also try the suggestion of only having one tab.
Thanks very much.
