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:

 

=IF(I11="April",P14,IF(I11="May",Q14,IF(I11="June",R14,IF(I11="July",S14,IF(I11="August",T14,IF(I11="September",U14,IF(I11="October",V14,IF(I11="November",W14,IF(I11="December",X14,IF(I11="January",Y14,IF(I11="February",Z14,IF(I11="March",AA14))))))))))))

1 Reply

@tbulicki 

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

I'd do it like this:

S1427.png

The formula in J11 is

=XLOOKUP(I11,$P$13:$AA$13,$P$14:$AA$14)

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

=HLOOKUP(I11,$P$13:$AA$14,2,FALSE)