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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.