Excel Formula Question

New Contributor

I am using the following formula in my drop down menu on a excel sheet for billing......all the months formulate correctly with the appropriate data EXCEPT April.  I do not know why....any ideas?  Fromula below:



1 Reply


It should work - make sure that I11 contains April, without spaces before or after the word.

I'd do it like this:


The formula in J11 is


If you don't have Microsoft 365 or Office 2021, use