Forum Discussion
catherine9910
Feb 23, 2022Brass Contributor
Formula with Drop Down
My question is in the workbook. But I want to return the month 2021 based on a drop down. For example if B2 says January, I want cell B6 to return January 2021.
Thanks in advance.
2 Replies
- Riny_van_EekelenPlatinum Contributor
catherine9910 You could just enter =B2&" 2021" in B6, I guess.