LOOKUP and Filter Based on Combined Condition

Dear Glenn,

Thanks a lot. its working well. i need support for following requirement also.

1. is it possible to generate linear curve automatically when data available
2. can we bring the linear regression equation from graph to cell when i entered the date in the summary sheet.

attaching excel sheet for your reference.

this excel sheet has only 20 rows. thanks a lot supporting continuously.