Match two criteria to generate data in other format

[lmmay]

I produce a weekly work log of time spent on various Disasters for my Disaster Recovery Director. The Grant Administrator requires a monthly Management Hours report in a different format.

I wish to automate the process. I am presently using [IF(AND('Work Log'!C58=1819,'Work Log'!e58'MGMT HRS 9-14(HM)'!A6='Work Log'!A58),'Work Log'!E58,"")].
This is quite cumbersome, since it requires modifying each cell. Is there a Match formula to make my life easier?
Sheet 1 (9/1/14) is Col A57, Sheet 2 (9/1/14) is Col A6.

Work Log						Management Hours
Sheet 1						Sheet 2
DAY	APPLICANT	DR	Description	HOURS		DATE	1819	1918	1975	1861	4100	4124	4143	4160	4174	HRS
Monday, September 1, 2014	Newton County	4143	Reviewed email from	1		Monday, September 1, 2014										0.0
Tuesday, September 2, 2014	Carroll County	4143	Reviewing PW 019	7		Tuesday, September 2, 2014	8.0									8.0
Wednesday, September 3, 2014	Newton County	4143	Printing, reviewing to r	1		Wednesday, September 3, 2014	8.0									8.0
Wednesday, September 3, 2014	Carroll County	4143	Reviewing PW 019-re	7		Thursday, September 4, 2014										0.0
Thursday, September 4, 2014	Newton County	4143	Review PW 11	2		Friday, September 5, 2014										0.0
Friday, September 5, 2014	Carroll County	4143	Review PW 019	6		Saturday, September 6, 2014										0.0
Monday, September 8, 2014	Newton County	4143	Review PW 11, email	8		Sunday, September 7, 2014										0.0
Tuesday, September 9, 2014	Newton County	4143	Completed review of	8		Monday, September 8, 2014	3.0							5.0		8.0
Wednesday, September 10, 2014	Arkansas VEC	4160	Sorting Documents fo	8		Tuesday, September 9, 2014								8.0		8.0
						Wednesday, September 10, 2014								8.0		8.0
						Thursday, September 11, 2014										0.0

<tbody>
</tbody>

 

[konew1]

Please check the formula you are using, The part in red seems to be incomplete

[IF(AND('Work Log'!C58=1819,'Work Log'!e58'MGMT HRS 9-14(HM)'!A6='Work Log'!A58),'Work Log'!E58,"")].

 

[lmmay]

Please check the formula you are using, The part in red seems to be incomplete

[IF(AND('Work Log'!C58=1819,'Work Log'!e58'MGMT HRS 9-14(HM)'!A6='Work Log'!A58),'Work Log'!E58,"")].

You are right. The formula actually reads:

=IF(AND('Work Log'!$C58=1819,'MGMT HRS 9-14(HM)'!$A6='Work Log'!$A58),'Work Log'!$E58,"")

Also, somehow when the HTML was created the DR numbers became erroneous. The first four should be 1819 and the last four should be 4160.

 

[lmmay]

Solved. Thanks