I have a formula that stopped working and I can not figure out why. I checked all points to make sure it is pointing to the right cells and made sure I pressed CTL+SHIFT+ENTER to do the array but it still does not work. I am stuck on what is going on. The formula pulls the last months net charges
Here is the formula
I also attached a example of the data![]()
=IFERROR(TEXT(INDEX(AD$2:AD2,MATCH(A2&EOMONTH(U2,-1),A$2:A2&U$2:U2,0),1),"$#,##0.00"),"")
Bookmarks