Once the PAID OFF is found , how do I take the $300 and put it into a cell in
the Loan 2 column so tht I can now use the $300 to pay-down loan 2.

"Toppers" wrote:

Use MATCH function to find 1st occurence of "PAID OFF"


e.g.

=MATCH("PAID OFF",A1:A500,0)

"Cas" wrote:

I have checked other posts but can not find an answer to this.
I am creating a Pay-down applicaton which will work in conjunction with a
budget.
Loan 1 min payment is $100. But we have an extra $200 we can pay. so we now
pay a total of $300 on Loan 1. When it paid off, I use the extra 300 on loan
2.
I need to have a way to search the column for the word PAID OFF anywhere in
the column. When I find PAID OFF I can then take that total amount of $300
and then start applying to loan #2. I have tried to do an IF with an OR
but can not figure out how to search any cell in a particular column for the
word PAID OFF, then move the amount that was being paid over to the next loan.
Thanks for your help
Cas,
The GCSpecialist


Loan # 1 Loan # 2
Extra Payment = 200 Extra Payment = 300 (From Loan 1)
Total Min Total Min
owed Payment=100 Owed Payment=200
5/1/2007 1000 300 5000 500
6/1/2007 700 300 4500 500
7/2/2007 400 300 4000 500
8/2/2007 100 100 3500 500
9/2/2007 PAID OFF PAID OFF 3000 500
10/3/2007 PAID OFF PAID OFF 2500 500
11/3/2007 PAID OFF PAID OFF 2000 500
12/4/2007 PAID OFF PAID OFF 1500 500
1/4/2008 PAID OFF PAID OFF 1000 500
2/4/2008 PAID OFF PAID OFF 500 500
3/6/2008 PAID OFF PAID OFF PAID OFF PAID OFF
4/6/2008 PAID OFF PAID OFF PAID OFF PAID OFF