I have an excel spreadsheet with company names in column A, sales team member names in column B and amounts in column C - which is the 2007 sales target numbers.
I have a spreadsheet with Sales team member column A, company names in column B and amounts in column C - which is the actual sales. This is imported into excel.
Can anyone help advise the appropriate formula to use to enable me to track actual vs target sales by sales team member and client?
Is it vlookup I should use?
I have a spreadsheet with Sales team member column A, company names in column B and amounts in column C - which is the actual sales. This is imported into excel.
Can anyone help advise the appropriate formula to use to enable me to track actual vs target sales by sales team member and client?
Is it vlookup I should use?