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
Many of the writers on this site make a living exclusively by buying and selling Magic cards
You Cannot Hide from Me Ongoing Scheme (An ongoing scheme remains face up until it's abandoned.) At the beginning of combat on your turn, up to one target creature gets +2/+2 and gains vigilance until end of turn
(2026-03-20) A preparation card is a creature card in every zone
Elspeth, Storm Slayer The halo foil, showcase version of the enchantment "Elspeth, Storm Slayer" is currently valued at $301.90, according to TCG Player Market Price
