Advertisement
ogre_x

Matchning på kolumn/rad

Jan 19th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. =index({$A$62:$A$66};
  2. 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