=LOOKUP(MONTH)
You're a star I appreciate your help, it works!!!!
"Toppers" wrote:
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" wrote:
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?
|