Matching values from 2 columns and returning the value in 3rd column

I have been trying to work out this formula for days without any luck. Please see attached file for a better udnerstanding of what I am trying to achieve.

I need to lookup the value in column a and match this to a value in column b to return the value that appears in column e. For example, i want to know how much time Tim Smith has spent on training creation, then i would need to check a11 and b11 and the value i want the formula to return is e11.

Please can someone assist with the formula I need to be using?

Thanks in advance!

Thanks for the swift reply.

My apologies, but I didn't give the full picture on what I am trying to achieve, so I am still having some problems with the formula.

I have 2 worksheets in a spreadsheet, the raw data (what you saw previously) and a main worksheet where I am trying to pull certain data into. I have attached the full file now.

In the 'Main' worksheet in cell e4, is where i want the output of the formula you have written to be presented. How can I do this?

Eventually my 'Main' file will contain all of the task names that appear in the 'Raw Data' file, so can I easily adapt the formula so that I can output the value per task name and dependant on the resource?

Thanks!

Can you possibly show me the working example as when i copy the formula into my spreadsheet, i am getting the value 0.00 returned whereas it should be 0.3

Thanks

Hi - So grateful for your help. But I am new to this site, and although I opened your updated file when you first sent it to me, I wasnt able to properly review it. Now, when I click on the link some other data appears in the file. Can you reattach the previous file for me please so that I can see the working example again?

Thanks!!

I just saw that you had replied to me, thanks so much.

I have reattached the file for you now.

Thanks.