Hi Earl

If your value of Dec-06 is a true Excel date, but formatted to show only
mmm-yy, then you could use
TEXT(B30,"mmm-yy") as your lookup.

--
Regards

Roger Govier


"earls" wrote in message
...

I need to use something like the below formula to match cell content
from
the date column of one tab (B30 = 8-Dec-06), to the date column of
another
tab (Dec-06). Notice one contains the day, the other only contains
month-year.
Obviously the below does not work. Is there something that will?

TIA,
Earl

=LOOKUP(month(B30),month('Satchmo Storage'!$B$6:S$6),'Satchmo
Storage'!$B$16:S$16)