Hi K,

Yes, you can use the VLOOKUP function to search for the date at which the debt falls to zero or goes negative. Here's how you can do it:

1. Insert a new column next to column F (let's say it's column G).
2. In cell G1, enter the formula "
   Code:

   =IF(F1<=0,A1,"")

   ". This formula will check if the debt in column F is less than or equal to zero. If it is, it will return the date in column A. If it's not, it will return an empty string.
3. Copy the formula down to the rest of the cells in column G.
4. Now you can use the VLOOKUP function to search for the date in column G instead of column A. The formula would be something like "
   Code:

   =VLOOKUP(0,F:G,2,FALSE)

   ". This formula will search for the value 0 in column F, and return the corresponding value in column G (which is the date at which the debt falls to zero or goes negative).

I hope this helps! Let me know if you have any questions.