Formula with Drop Down

[catherine9910]

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]

Hi @catherine9910 

Please find the file with the correct formula you were trying to create.

[#3]

@catherine9910 You could just enter =B2&" 2021" in B6, I guess.