Column B has the age range. Column H shows when the funds will run out. I would like a formula that can lookup up the age in column B to determine when the fund will run out. In the attached, the funds will run out at age 85.
Column B has the age range. Column H shows when the funds will run out. I would like a formula that can lookup up the age in column B to determine when the fund will run out. In the attached, the funds will run out at age 85.
Try
=INDEX(B:B,MATCH(0.01,H:H,-1)+1)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Okay, try using below formula:-
=INDEX($B$1:$B$85,MIN(IF($H$39:$H$85<0,ROW($H$39:$H$85),"")))
Enter this using key combination: ctrl shift enter
Regards,
DILIPandey
Thank you both for you knowledgeable help!
You are welcome...
cheers
Regards,
DILIPandey