Current Month Formula

I am trying to create a formula that shows:

If current month (A2 in YoY Sheet) is equal to the month in column A (2018 Sheet) then show the data in column B for that month (2018 Sheet) in cell A5 (YoY Sheet) and so on and so forth. (images below)

If I can just get this formula down then I can get the rest of the data for this.

Thanks in advance for any help.

1.png

2.png

It would have been easier to visualise if you had uploaded the workbook but perhaps

Formula:

Please Login or Register  to view this content.

However upload the workbook and manually add the results you expect for a definitive solution.

Oh dear!

You are committing the cardinal sin of using merged cells. Most of us avoid them like the plague since they just cause too many problems for all sorts of reasons that needn't concern us here. They WILL come to bite you in the backside and you should seriousy consider changing your layout.

That said there is no month in A2 on YOY sheet so I have no idea how you expect this to work.