Forum Discussion

tbulicki's avatar
tbulicki
Copper Contributor
May 13, 2022

Excel Formula Question

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))))))))))))

Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 13, 2022

    tbulicki 

    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

    =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)

Resources