Help in IF( And( or) Statement

[jawaharprm]

Hi Team,

I need to update month by number.

Example : - if 1=jan, 2 - Feb

please help on this formula..

Month
1
3
5
4
i used this formula getting error please help on same

if(or(and(A2="1","Jan"),and(A2="5","MAY"))

Thanks
Jawahar

 

[pecoflyer]

Try =TEXT(A2*29,"mmm")

 

[GraH - Guido]

What also works if you have a modern version
=SWITCH(A2, 1, "Jan", 2, "Feb", 3, "Mar", ...)
or for older versions
=LOOKUP(A2, {1,2,3,4,5,6,7,8,9,10,11,12},{"Jan","Feb,"Mar", ....,"Dec"})
or
=INDEX({"Jan","Feb,"Mar", ....,"Dec"}, A2)
or ...

Many ways to Rome in this case.

 

[pecoflyer]

Many ways to Rome in this case.

Yes, but mine is the shortest

 

[GraH - Guido]

Yes, but mine is the shortest

It's stunning too (I had a wrong reference before, so delete the "stupid" post)