Replace #VALUE! with UNK
 

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?

Replace #VALUE! with UNK
 

Hi

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

=RC[-43] and format the cell as FormatCellsNumberCustom mmm

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

--
Regards

Roger Govier


"SS" wrote in message
...
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?

Replace #VALUE! with UNK
 

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

"Roger Govier" wrote:

Hi

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

=RC[-43] and format the cell as FormatCellsNumberCustom mmm

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

--
Regards

Roger Govier


"SS" wrote in message
...
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?