ogre_x icon

Matchning på kolumn/rad

ogre_x | PRO | 01/19/19 01:35:26 PM UTC | 0 ⭐ | 279 👁️ | Never ⏰ | []
text |

430 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
=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))

Comments