INDEX and MATCH to lookup value to the left and -1 row

Dear Excel-friends,

I want to look up one value to the leff-column and if that value of higher than 4.55%, it should go back one row (row-1) and extract the value in that row. I have done that but I always get one "SPILL!" error after one value is found, that kind of mess up the sheet and for the few times two values after each other in a row is higher than 4.55%.
Tried to search and implement solutions from this forum, as normal, but couldn't figure it out...

Basically, if the looked-up range is in Column A, and in A54 the value is 6%, I want to get the value before 6% in A53 extracted to my new column.

Thank you for the help, I appreciate that a lot!

Best Regards
Ctrl+V

E3 =IF(D4="","",IF(D4>$H$3,D3,"")) and drag down

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.