On one sheet, in one cell (b1), I have a drop down menu. A menu of the 12 months (jan-dec). On another sheet, there is a cell (A1) that equals whatever is chosen from the drop down menu.

I am using a hlookup formula with the reference cell = A1. The formula does not work due to the reference cell being a formula.

Any suggestions? I can not get rid of the drop-down menu, it would defeat the whole purpose of my workbook.

Thanks for the support!