Team Readiness query - baerrach/msf-googlesheet-tools GitHub Wiki

SpiderManNoir | GhostSpider | PeterBParker | PeniParker | SpiderManPavitr
=QUERY(Roster!A:W, "select A, B, G, N, O, P, Q, R where B matches '" & A1 & "|" & B1 & "|" & C1 & "|" & D1 & "|" & E1 & "'")

Header Name	Header Column
Name	A
Character Id	B
Gear Tier	G
Striker	N
Fortifier	O
Healer	P
Raider	Q
Skirmisher	R

Type the five names of the team in A1 to E1

In A2 enter the query.

The results will be alliance members with character Ids and their readiness data