PDA

View Full Version : [SOLVED:] Lookup up formula


av8tordude
04-08-2014, 02:18 AM
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.
Bob Phillips
04-08-2014, 03:07 AM
Try

=INDEX(B:B,MATCH(0.01,H:H,-1)+1)
DILIPandey
04-08-2014, 03:08 AM
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
av8tordude
04-09-2014, 04:57 AM
Thank you both for you knowledgeable help!
DILIPandey
04-09-2014, 05:29 AM
You are welcome...

cheers :)

Regards,
DILIPandey