Do you mean B8, not B6??? You didn't show expected results; but is this what you wanted:
=IFERROR(INDEX('Year Projections'!$C$6:$N$13,MATCH(Journal!$A16,'Year Projections'!$A$6:$A$13,0),MATCH(Journal!$B$8,'Year Projections'!$C$5:$N$5,0)),"")
copy down as needed.
Bookmarks