Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =index({$A$62:$A$66};
- match(max(INDEX({Hamed!A3:BR66}; MATCH("XP"; Hamed!A:A; 0); MATCH("201903"; Hamed!1:1; 0));INDEX({Fredrik!A3:BR66}; MATCH("XP"; Fredrik!A:A; 0); MATCH("201903"; Fredrik!1:1; 0));Johan!BQ4;Roy!BQ4;Dennis!BM4); {INDEX({Hamed!A3:BR66}; MATCH("XP"; Hamed!A:A; 0); MATCH("201903"; Hamed!1:1; 0));INDEX({Fredrik!A3:BR66}; MATCH("XP"; Fredrik!A:A; 0); MATCH("201903"; Fredrik!1:1; 0));Johan!BQ4;Roy!BQ4;Dennis!BM4}; 0))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement