That's wild Join the conversation
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
These are usually independently-owned businesses that appraise, buy, sell, and trade Magic cards
I mean, youre gonna be less likely to drop a bunch of creatures on the field if you know a board wipe could kill you, right
Oh look, there are so many vampires in Blood Rites
