Returning a value based on multiple criteria

Dear Forum,

I wonder if you can help

I have a spreadsheet with the following columns of data:

A = Entry date
B = Project Number
C = Approximate employee hours to complete project

(All columns may contain duplicates values within the column)

In cell D1 I want to enter one of the project numbers and for a formula in E1 to return the most recently entered 'Approximate employee hours to complete' value for that project from column C

Many thanks in advance for your help

Kind regards

Alex

=lookup(100000,$a$3:$a$800/($b$3:$b$800=e1),$c$3:$c$800)