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.
Riny_van_Eekelen
Feb 23, 2022Platinum Contributor
catherine9910 You could just enter =B2&" 2021" in B6, I guess.