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
|