Select value from range based on adjacent values.

[smhelgerson72]

NOTE:
This next part has been expertly solved, but I'm keeping it in here for context:
Hey folks!
I need to be able to populate a cell with information similar to but modified from the cell next to it. In other words, if one cell says FY22 MCGUIRE, I need the cell next to it to say FY22. Or if the cell says Oct-21, I need the cell next to it to say OCT.
I also need the original cells to be drop-down lists.
The solution I came up with is to provide an array of dates for Excel to choose from. That way, when I select the year, it gives me a list of months to choose from. But it's determining the value of the adjacent cells that's troubling me.
I attached a spreadsheet so you can see what I mean. In the sheet, I need to update cells N2 and N4 such that if M2 says FY22 MCGUIRE, then N2 says FY22, and so that if M4 says Oct-21, N4 says Oct.

This next part is the new question:
In the attached spreadsheet, I have a range of date ranges in cells M15:V26. I need to be able to update the value of cell M6 with the corresponding date range based on the selections of cells M2 and M4. For example, if I select FY25 MCGUIRE, and May-25, I need M6 to show 05/01/25-05/31/25.

Thanks!

Shawn.