Hello,

In (B2) I have the following formula:
=VLOOKUP(MONTH(A5),Lookup!$A$13:$B$24,2,FALSE)

This gives me the month based on a date entry in (A1). I need to say if A1
is blank then B2 should remain blank as well.

Also, is there a way to auto copy formulas down without manually pulling
them down to the next row?

Thank you