Find the last occurrence of a value in multiple columns or a matrix

I have a spreadsheet that tracks hymns for given date. A simplified verion of it look like this:

	A	B	C	D	E	F	G	H	I
1	Date	Chorister	Organist	Hymn #1	Hymn #1 Title	Hymn #2	Hymn #2 Title	Hymn #3	Hymn #3 Title
2	Oct 19, 2014	Joe	Jane	140	Lorem ipsum	190	dolor sit amet	19	consectetur
3	Oct 26, 2014	Jack	Jenny	144	adipiscing elit	191	Vivamus dui nisl	141	elementum id
4	Nov 2, 2014	Jeff	Jill	229	sodales sit amet	192	rutrum nec justo	107	Sed sollicitudin
5	Nov 9, 2014	John	Joyce	94	diam nec tempus	193	adipiscing	237	nisi elit
6	Nov 16, 2014	Jim	Janet	21	malesuada	194	nulla, quis	231	congue velit
7	Nov 23, 2014	Jake	Jacqueline	93	arcu et mauris	195	Vestibulum	96	et egestas
8	Nov 30, 2014	Jared	June	210	ipsum	202	Aliquam	92	nisl metus
9	Dec 7, 2014	Jason	Jean	212	pellentesque	197	ac nulla id,	211	posuere
10	Dec 14, 2014	Jed	Jessica	209	semper nisl	146	In purus dui,	213	varius sed
11	Dec 21, 2014	Jesse	Johanna	205	posuere ut	169	suscipit et magna	208	Ut suscipit
12	Dec 28, 2014	Josh	Julie	207	sed sem	170	ut consequat	202	Curabitur

On a separate sheet I have a spreadsheet of which a simplified version which should eventually look like this:

	E	F	G	H
1	Hymn #	Title	Last Sung (date)	# of Times Sung
2	201	Lorem
3	202	ipsum	Dec 28, 2014	2
4	203	dolor
5	204	sit amet
6	205	consectetur	Dec 21, 2014	1
7	206	adipiscing elit
8	207	Vivamus	Dec 28, 2014	1
9	208	dui nisl	Dec 21, 2014	1
10	209	elementum	Dec 14, 2014	1

First, I'm looking for a formula that will look at the matrix in the first sheet, find the last occurrence of the corresponding hymn # from the second spread sheet, and then copy the date from the corresponding row in column A of the first spreadsheet to the appropriate cell in column G on the second spreadsheet.

Second, I'm looking for a formula that will look at the matrix in the first sheet, count the total number of times a given hymn # appears, and then place that total in the appropriate cell in column H on the second spread sheet. (This helps me spot duplicates.)

I've tried using various combinations of SUMPRODUCT, MAX, ROW, INDEX, and SUMIFS, but can't seem to get the anything but errors.

Any help would be appreciated.