asked on

Lookup Payoff Date

Please see the attached spreadsheet. (and image file)
What I would like to do is lookup the earliest Payoff date.

For example, if I pay 350 per day, the payoff date should be 1/30/2015
if I pay 400 per day, the payoff date should be 1/26/2015

If you need more info, ...let me know.
;-)

JeffCoachman

Ryan Chong

not too sure if your intention is to calc the paid off date?

see attached for demonstration
28792419.xlsx

Jeffrey Coachman

ASKER

thanks ryan,

Sorry if I was not clear
What you have works, ...but I want to use this as a visual aid, ...so I want to see all the dates and amounts,...
I want the payoff date to appear in cell H2 (along with all the data)
...as shown in the screenshot and the sample file.

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

ASKER

Thanks!, ...both work

Jeffrey Coachman

ASKER

Thanks!

Jeffrey Coachman

ASKER

...Great solutions as one solutions keys off of the text, ...and the other keys off of the amount....
;-)

Subodh Tiwari (Neeraj)

You welcome Jeffrey!

I preferred Amount column as this is the base column for all the calculations where as the text column is dependent column and it also depends on Amount. :)