Excel Formula Question

%3CLINGO-SUB%20id%3D%22lingo-sub-3368237%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3368237%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20following%20formula%20in%20my%20drop%20down%20menu%20on%20a%20excel%20sheet%20for%20billing......all%20the%20months%20formulate%20correctly%20with%20the%20appropriate%20data%20EXCEPT%20April.%26nbsp%3B%20I%20do%20not%20know%20why....any%20ideas%3F%26nbsp%3B%20Fromula%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(I11%3D%22April%22%2CP14%2CIF(I11%3D%22May%22%2CQ14%2CIF(I11%3D%22June%22%2CR14%2CIF(I11%3D%22July%22%2CS14%2CIF(I11%3D%22August%22%2CT14%2CIF(I11%3D%22September%22%2CU14%2CIF(I11%3D%22October%22%2CV14%2CIF(I11%3D%22November%22%2CW14%2CIF(I11%3D%22December%22%2CX14%2CIF(I11%3D%22January%22%2CY14%2CIF(I11%3D%22February%22%2CZ14%2CIF(I11%3D%22March%22%2CAA14))))))))))))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3368237%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3369179%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3369179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1389052%22%20target%3D%22_blank%22%3E%40tbulicki%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20should%20work%20-%20make%20sure%20that%20I11%20contains%20April%2C%20without%20spaces%20before%20or%20after%20the%20word.%3C%2FP%3E%0A%3CP%3EI'd%20do%20it%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1427.png%22%20style%3D%22width%3A%20875px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371381i2094B4D3B7C020AD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1427.png%22%20alt%3D%22S1427.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20formula%20in%20J11%20is%3C%2FP%3E%0A%3CP%3E%3DXLOOKUP(I11%2C%24P%2413%3A%24AA%2413%2C%24P%2414%3A%24AA%2414)%3C%2FP%3E%0A%3CP%3EIf%20you%20don't%20have%20Microsoft%20365%20or%20Office%202021%2C%20use%3C%2FP%3E%0A%3CP%3E%3DHLOOKUP(I11%2C%24P%2413%3A%24AA%2414%2C2%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)