Making my Formula F1 Race
 

What I am trying to do is make Excel provide me with the next bill due.

In F1, I have:

=IF(ISERROR(MATCH("*",F4:F2000,-1)),"*",INDEX(F4:F2000,MATCH("*",F4:F2000,-1))) (provided by Stefi)

In cells A4:A2000, I manually place an "x" and the formula in F1 works.

In cells C:C, I will have the dates my bills are due, e.g.

c4 | 12/02/06
c5 | 12/10/06
c6 | 12/15/06
c7 | 12/20/06

Cells F4:f2000 checks to see if A4:A2000 is checked, e.g.

F4 =IF(A4<"",B4,"")
F5 =IF(A5<"",B5,"")
ETC.

Now, the F1 formula works perfectly if I don't have any blank cells in
A4:a(Whatever the last cell that I have an €œx€�). In other words, if I put an
"x" by the next bill due, F1 formula does what its supposed to. However, if
I remove the preceding €œx€�, then the F1 formula seems to balk.

Any suggestions on how to make the F1 formula work the way I need?

Thanks in advance.