=LOOKUP(MONTH)

S

SS

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?
 
T

Toppers

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
 
R

Ron Coderre

Not a LOOKUP solution, but perhaps this will work:

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

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

XL2002, WinXP
 
S

SS

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

Toppers said:
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

SS said:
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?
Click to expand...
Click to expand...
 
Top