Displaying cell value if 2 other cells display the exact results

[Streaky]

Apologies if my thread title is confusing but I don't know how to put it other than that.

I have an excel sheet that I am trying to put together to make my life easier but I cannot figure out what formula or function(s) I need to use to get it to display what I want from it, I'll try to explain so please bare with me and I've attached the file so that you can potentially see what I'm talking about.

I want to use the 'data dump' tab to, on a daily basis, drop in the performance of agents from the previous day (I get this info emailed to me).

I a formula that will automatically populate the individual agents 'talk time' into the other cells where the criteria for the name and date match as we measure them against their targets and I want to be able to feedback to them a lot more frequently as to how they are performing to target.

I have a basic grasp of some excel functions but as this one is looking at multiple fields in order to display a result I am well and truly stumped and was hoping someone here may be able to tell me what I'm doing wrong.

I hope I've explained that properly, please ask if you need anymore info

[gak67]

This should work in B3 of your TAM, HAM and SAM sheets and copied down and across

Please Login or Register  to view this content.

[Streaky]

to simplify it more (as it might help) in an example I want column B3 in the 'TAM' tab to display the result of column C in the 'data dump' tab if column a (in 'data dump) equals 'Ross Benjamin' and column B (in 'data dump') equals '01/04/2014'

I'll then use the same formula for the other agents by changing the name value.

[sktneer]

Try this in B3

Please Login or Register  to view this content.

and copy across and down.
Is this what you are looking for?

[gak67]

You mean like this:Talk Time Stats.xlsx

[Streaky]

This should work in B3 of your TAM, HAM and SAM sheets and copied down and across

Please Login or Register  to view this content.

that has worked to a tee, thank you very much. It was driving me nuts