Find value in a column at today month date

Find value in a column at today month date

I need to find a positive value (if there is one) based on current month return
In summary:
A5:A16 are months Jan through to Dec
H5:H16 are returns for any values for that month
H19 is to return the latest value in the column
=LOOKUP(2,1/(H4:H16<>""),H4:H16) works fine but will record latest historic value entered.
I need to expand this to give the latest value for the current month.
See attachment - as it is August I need the H12 value for August returned to H19 not a 0 from H16. When it becomes Sept (tmrw) I will need the H13 value from Sept returned.
Hope that makes sense
Appreciate any help, Thanks

Try this ...

=VLOOKUP(TEXT(TODAY(),"mmm"),$A$5:$H$16,8,0)

Thanks - on testing pulls in August value. So clearly working for current month of August
Will it find the Sept value tmrw ?
I cannot seem to follow the logic in the formula to see how it knows to look in a different cell in column H each month. What doe the ,8,0 at end of formula do?

Thanks all