Formula to search column for match and output date in corresponding row

Hello,

I am trying to make a formula that searches through a column of dates by year, matches today's current year and then outputs adjacent row data.

Specifically trying to automatically pull yearly Cumulative Interest in a Loan Amortization chart by today's date (year).

i think the if function will work but seemed very cumbersome with how i basically understand it. I didnt want to type in 25 to 30 if functions! There has to be a better way!

=if(YEAR(NOW())=b27, h27,if(YEAR(NOW())=b28,h28,if(YEAR(NOW())=b29,h29,if....and so on

Thank you

That did it! Thank you sir!