Spreadsheet: 55197d1255367010-multiple-lookup-and-iserror-help-sample
Sheet: Background sales rep comparison

 |  |  |  |  |  | KF |  | LI |  |  |  |  |  |  |  | Sales Rep 1 | % of total | [NAME] | % of total | [NAME] 3 | % of total | [NAME] | % of total | Sales Rep 5 | % of total | Sales Rep 6 | % of total | Sales Rep 7 | % of total | Sales Rep 8 | % of total | Sales Rep 9 | % of total | Sales Rep 10 | % of total | Sales Rep 11 | % of total | Sales Rep 12 | % of total
 |  |  |  |  | Activity list | SalesRep4 |  | SalesRep5 |  | KF | LI
 | Sales rep list |  |  | Z | Sales Activities |  |  |  |  |  |  |  |  | A | Lead Generation Time | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | AL | SalesRep1 |  | A | Customer contact - new business (needs' investigation, solution presentation, price negotiation, follow up of bid, deal closing) |  |  |  |  |  |  |  |  | B | Initial Pricing | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | IS | SalesRep2 |  | B | Contact with Customer as part of contact strategy, as health check or for renewal negotiations |  |  |  |  |  |  |  |  | C | Lead Qualification Meeting | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | KG | SalesRep3 |  | C | Office activities for new business (pricing strategy, bid creation, order building & processing) |  |  |  |  |  |  |  |  | D | Credit Check | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | KF | SalesRep4 |  | D | Office activities for renewals (communications with Cust.Care, contracts creation for special deals etc) |  |  |  |  | KF | LI |  |  | E | Requirements Testing | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | LI | SalesRep5 |  | E | Update info in CRM & SFA tools (HVC application) |  |  |  |  |  |  |  |  | F | Bid Creation | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
 | MC | SalesRep6 |  | F | Extract info from CRM / SFA for customer meetings of the day |  |  |  |  |  |  |  |  | G | Bid Review Meeting | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
 | MP | SalesRep7 |  | G | Critical customers' info exchange with Customer Care CSR |  |  |  |  |  |  |  |  | H | As-is contracts | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
 | TV | SalesRep8 |  | H | Activities with Internal VF organisation to solve all isuues, non related to account manager's sales duties (*) |  |  |  |  |  |  |  |  | I | Contracts needing amendments | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A |  | #N/A
 | VN | SalesRep9 |  | I | Customer Queries - Provide Info to customer for all areas |  |  |  |  | Method Of input |  |  |  | J | Obtain Sign-off | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | VP | SalesRep10 |  | J | One-to-one coaching with supervisor |  |  |  |  | #N/A |  |  |  | K | Update Info | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | #N/A | SalesRep11 |  | K | Customers' lists management for events, gifts, promos, business club etc (create list with prospects, call or visit to inform customers, inform admin for final list) |  |  |  |  | If above says a then it uses the activities and time at activities input |  |  |  | L | Complaints | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | #N/A | SalesRep12 |  | XY | Non-Sales Activities |  |  |  |  |  |  |  |  | M | Customer Queries - Billing /Tariffs | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | L | Internal Sales Meetings |  |  |  |  |  |  |  |  | N | Customer Queries - Service Issue | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | M | Results & Achievements'  comparison vs actual sales orders |  |  |  |  |  |  |  |  | O | Customer Queries - Customer Details | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | N | Account Review & Analysis |  |  |  |  |  |  |  |  | P | Contract Renewal Process | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | O | Product & Skills Training |  |  |  |  |  |  |  |  | Q | Change Requests | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | P | Travel (from and to customers) |  |  |  |  |  |  |  |  | R | Internal Meetings | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | Sales Management - Forecasting | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | T | Sales Management - Reporting | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | U | Sales Management - Account Analysis | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | V | System Activity (Booting) | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | X | [NAME] | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | Product Specific Training | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | XX | Travel | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0 | #N/A | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | Sales Activities |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | XY | Non-Sales Activities |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0