Hlookup does not work due to reference cell being a formula

Originally Posted by cappadona

the dates match exactly. The drop-down menu only includes October, November and December. If I chose December, the hlookup finds December's numbers fine but October and November show up as N/A.

Can you post the formula?