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.
Printable View
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)
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