Formula to return values from the corresponding month's column into a different tab

[parsenov]

Hello,
I am looking for a way to return data based on current month. The attached file has two tabs - A and B. B keeps a running total of sales for each month. A is what i submit to managers and they dont need to see the whole year worth of data - only the current month. I manually enter the month in the yellow fields. So basically i need C9 from tab A to return AA11 from tab B for September, C9 from tab A to return AD11 from tab B for October and so on. I could change the months names in line 5 from tab B if that will make it easier.

Thank you.

Edit: I basically want to enter data in tab B only and the formula to return values of the designated month in tab A.

[MrChrisP]

Hello,

With these kind of sheets it is always worth having a datasheet where you keep the raw data stored in a standard format/layout.

See the attached. I have taken your worksheet and added a DataTable sheet which contains the same info as in rough data, but in a format that is easier to use with formulas.
Using that data a simple VLookup will provide the solution you require. All you need to do is input the data into the DataTable and then change the current month in Cell I3. Simply type Sep-19 for the next month and so on.

You can make this work a lot better my naming ranges etc, but for now this should set you on the right path. Likewise with a datasheet you can easily replicate all of what you need and more by using pivot tables.
It also makes things easier when selecting data for charts and other visualizations.

Hope this helps, but if you have any other questions please feel free to ask.

Cheers,
MrChrisP

[parsenov]

That, sir, will fix my problems. I inherited this sheet and was a mess in the beginning so i will no hesitate to change my rough data to the table format you suggest.
Thank you very much for your help.