Hi

Try this:

=IF(cell="","NA",IF(ISNA(VLOOKUP(MONTH(cell),Looku pMonth,2,FALSE)),"NA",VLOOKUP(MONTH(I12),LookupMon th,2,FALSE)))

Regards,
Per

"Charlie" skrev i meddelelsen
...
How do I get around the MONTH(cell) function returning 1 (Jan) when
evaluated
against what I consider to be an empty date cell?

I'm using it within ...
IF(ISNA(VLOOKUP(MONTH(cell),LookupMonth,2,FALSE)), "NA",VLOOKUP(MONTH(I12),LookupMonth,2,FALSE))

I was expecting it to return NA