Hi Steve- Paste this ARRAY FORMULA* on row 5 (or change the $A5 reference) and copy down:
=IFERROR(INDEX('Dec. ''16'!$P$3:$P$1006,MATCH(LEFT(TRIM(Summary!$A5),4),LEFT(TRIM('Dec. ''16'!$H$3:$H$1006),4),0)),"")

*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.


Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee