Forum Discussion
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? Fr...
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)