So this is what I need help with and I'm not sure I can even do it using Excel. I work in a call center and during the season we QA both phone calls and Email responses from the seasonal staff. I am ideally wanting a sheet that has a dropdown for the rep name and a dropdown for the week (Jan 15 for example). I then will have 2 additional cells for the Phone and Email.

Based on which name and date I choose in the dropdown, I would like the phone and email cells to look at a specific cell on another sheet IE. I pick Dave Smith and the week of Jan. 15, it looks to cell C2 on sheet 2 (for phone) and cell J2 on sheet 2 (for Email). I would like it to display 0 if nothing has been entered yet.

The tricky part and the part I'm not sure if I can do...I want these field to be editable and then to update sheet 2. So if I pick Dave and Jan 15 as above, after getting a 0, I want to change this to 2 (in the phone cell) as I just monitored 2 calls from him. This then needs to be carried over into the appropriate cell in sheet 2 (C2 in this example).

I have tried a few variations on functions to try and get it working but no success so far...I have tried using an IF statement and LOOKUP. I did discuss this with a coworker that is more knowledgeable than myself in Excel and she had tried to do it in a Macro but also with no success.

If someone has a better approach than what I'm thinking of doing I'm also open to suggestions.

Any help on this would be greatly appriciated and thanks in advance.