Case uitwerking Excel

Management




A B C D E F G H I J K L M N
1 INVOER UITVOER
2
=VLOOKUP($C4,
3 Verkoper Contacts Sales Sales/Contacts Commission
OzVERKOPERS,
4 Frank 644 4373400 6791 26240.4 MATCH(E3,
5 OZ_Per_Verkoper!$B$4:$F$4,
6 0),
7 Totaal Contacts Sales Sales/Contacts Commission 0)
8 All 3,124.00 22,745,149.00 55,848.00 166,291.00
9
=IF($C8=E$7,
10
INDEX(OZ_Per_Verkoper!$C$13:$F$13,
11 List MATCH($C8,
12 =INDEX(OzVERKOPERS,0,1) OZ_Per_Verkoper!$C$4:$F$4,
13 List 0)),
14 =POSTEN IF($C8="All",
15 INDEX(OZ_Per_Verkoper!$C$13:$F$13,
16 MATCH(E$7,
OZ_Per_Verkoper!
17
$C$4:$F$4,
18 0)),
19 ""))
20
21
22
23
24
25
26
27
28
29
30
31




docs_538038548.xlsx

, Comments

C4: List
=INDEX(OzVERKOPERS,0,1)


C8: List
=POSTEN


E4: =VLOOKUP($C4,
OzVERKOPERS,
MATCH(E3,
OZ_Per_Verkoper!$B$4:$F$4,
0),
0)


E8: =IF($C8=E$7,
INDEX(OZ_Per_Verkoper!$C$13:$F$13,
MATCH($C8,
OZ_Per_Verkoper!$C$4:$F$4,
0)),
IF($C8="All",
INDEX(OZ_Per_Verkoper!$C$13:$F$13,
MATCH(E$7,
OZ_Per_Verkoper!$C$4:$F$4,
0)),
""))




docs_538038548.xlsx