Replace #VALUE! with UNK

[Guest]

Hi

I have the following formula:
=IF(RC[-43]="","",LOOKUP(MONTH(RC[-43]),{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"}))

is it possible to incorporate that if I get an #VALUE! error that it can be
replaced by UNK?

 

[Roger Govier]

Hi

If you are just wanting to return the month name, then you needn't use
Lookup()

=RC[-43] and format the cell as Format>Cells>Number>Custom> mmm

or
=TEXT(RC[-43],"mmm")

 

[Guest]

thanks Roger, that was a great help - 2 hours of scratching my head, u
managed to sort in 5mins!!!!!!

Hi

If you are just wanting to return the month name, then you needn't use
Lookup()

=RC[-43] and format the cell as Format>Cells>Number>Custom> mmm

or
=TEXT(RC[-43],"mmm")

--
Regards

Roger Govier

Hi

I have the following formula:
=IF(RC[-43]="","",LOOKUP(MONTH(RC[-43]),{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"}))

is it possible to incorporate that if I get an #VALUE! error that it
can be
replaced by UNK?