Hi and welcome
why not in one go, something like

=INDEX(A:A,MATCH(A2,A:A)+C2,0)


Eventually post a sample sheet with some data and expected results

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post