Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Excel lookup, multiple conditions

Avatar of iits
iitsFlag for Australia asked on
Microsoft Excel
4 Comments1 Solution724 ViewsLast Modified:
Hi Experts

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).

Thank you!
Avatar of zorvek (Kevin Jones)
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers