Forum Discussion
Help with with Lookups etc.
Hi I’m looking for help as I’ve exhausted my knowledge and cannot sort this out. I have a spreadsheet with columns A-L. The sheet goes from A2:L90 (see attachment) Columns A and B are surname and...
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.
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.