=LOOKUP(MONTH)

[Guest]

When lookign up a range why does the =LOOKUP(MONTH) give values even if the
cell is blank

If I have
no date in A1 but have a formula in C1
(=LOOKUP(MONTH(RC[-2]),{0,1,2,3,4,5,6,7,8,9,10,11,12},{"
","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"})

it give me a value of Jan is there a way around this?

 

[Guest]

something like ...

=IF(A1="","",LOOKUP(MONTH(A1),{0,1,2,3,4,5,6,7,8,9,10,11,12},{"
","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"}))

HTH

 

[Guest]

Not a LOOKUP solution, but perhaps this will work:

=IF(A1<>"",TEXT(A1,"mmm"),"")

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

You're a star I appreciate your help, it works!!!!

something like ...

=IF(A1="","",LOOKUP(MONTH(A1),{0,1,2,3,4,5,6,7,8,9,10,11,12},{"
","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"}))

HTH

When lookign up a range why does the =LOOKUP(MONTH) give values even if the
cell is blank

If I have
no date in A1 but have a formula in C1
(=LOOKUP(MONTH(RC[-2]),{0,1,2,3,4,5,6,7,8,9,10,11,12},{"
","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"})

it give me a value of Jan is there a way around this?