Tasha wrote...
....
. . . So for instance in this months column AN, it displays JUL next
to each row of information. in AO, I would like it to show 7 months
current YTD, then next month show 8 and so on. . . .
....

One way,

=MATCH(AN2,{"Jan","Feb","Mar","Apr","May","Jun","J ul","Aug",
"Sep","Oct","Nov","Dec"},0)