Case uitwerking Excel

Admin




Salesforce Teams branch
Team1 connectors
Bob valves
Mark all
Ralph
activity
Team2 agriculture
Greg industry
Rachel home
Jon
period
Team3 Q1
Keith Q2
Peter Q3
Kim Q4


Team List
Team1
Team2
Team3




docs_052995179.xlsx

, Management




Input Area Output Area E5:
Met
Activity Quarter Total Bereiknaam =INDEX(
home Q1 732.00 732.00 ActivityPeriodSales!$B$3:$E$5,
MATCH(B5,ActivityPeriodSales!$A$3:$A$5,0),
MATCH(C5,ActivityPeriodSales!$B$2:$E$2,0))
Team Activity Total
Team2 industry 2,296.00 2,296.00 Alternatief:

=INDEX(APsales,
E9: MATCH(B5,INDEX(APsales,0,1),0),
=INDEX( MATCH(C5,INDEX(APsales,1,0),0))
TeamActivitySales!$B$3:$D$5,
MATCH(C9,TeamActivitySales!$A$3:$A$5,0),
MATCH(B9,TeamActivitySales!$B$2:$D$2,0))

Alternatief:
=INDEX(
TAsales,
MATCH(C9,INDEX(TAsales,0,1),0),
MATCH(B9,INDEX(TAsales,1,0),0))




docs_052995179.xlsx