I have an excel spreadsheet with 2 sheets.
Sheet 1 is called "Report" and is what I use to paste a web based report from our management software into excel - the example shows sample data in the format it appears. The number of employees could exceed 50, the products associated with the employee is NOT the same for each employee, if an employee sold zero of one product it will not show that row. The value next to the product - Column C is the quantity sold. Then there is sheet called Results, This table will show the column headers & list all the staff members in column A. I need the values on this sheet to be 'looked up' from the 'report' sheet. The totals do not need to be brought accross I will calculate these using SUM/SUMIF. I also need it to be compatible with Excel 2003 & any N/A values to be shown as zero (0).