Please help fix my ChatGPT formulas. Growth rate since January 2022.

CIVF Social Media and Website Analytics-2.xlsx

See attached document.

Formula in D6 is:
=IF(COUNTIFS(D8:D131, "<>""") <= 1, "",
(LOOKUP(2, 1/(D8:D131<>""), D8:D131) - INDEX(D8:D131, MATCH(TRUE, INDEX(D8:D131<>"", 0), 0))) / INDEX(D8:D131, MATCH(TRUE, INDEX(D8:D131<>"", 0), 0))
)

This formula compares the data in D8 to the most recent data provided. If cell D131 (December 2030) is blank, then it should look for data in D130, then D129 etc etc. It does this correctly.

However, when there is data in any of the January cells (except for D8), the formula doesn't work and gives me -100%. Delete what's in the January cell and the formula works again.

For example, if you open the document, you can see D6 says -100%. This is obviously incorrect. However if you delete the contents of D22, the formula works correctly.

I'm at a loss as to why. ChatGPT is unable to help me any further.

Is anyone able to help with this one? Thanks very much in advance.