It ignores the second IF function my current attempt is =INDEX(B:B,MATCH(LARGE(IF(D:D=Sector,IF(E:E=Sub Sector,F:F)),1),F:F,0)) where B:B = task name D:D = Sector names E:E = Sub Sector Names F:F = Priority Score V:V = Job Status (not above but required below) so ultimately what I want to be able to do is create a function that shows that if D:D has a specific name, and E:E also has a specific name, and V:V has names active, on hold OR unassigned then from the remaining list automatically on F:F search the top 3 scorers (or top scorer, 2nd, then 3rd by changing the parameter of large) and from which using xlookup/index.match to pull the task name from B:B so I mean, quite an easy one really I dont think Im asking for much thank you to anyone who even read all of that as I appreciate its a lot
Cursed tomes, libraries, and book-devouring monsters are common features of card art and accompanying stories
Creature - Human Rogue Color tag templates(None) Changeling Outcast Changeling (This card is every creature type.) This creature can't block and can't be blocked
Forged in the fires of Oath of the Gatewatch expeditions