I've never worked with VBA arrays before, and it's been many years since I
used them in a spreadsheet. Now I think they might help.

I have a spreadsheet with unusual dates. They're in MMM-YY format (no
days). I need to somehow convert them to month and year to compare with
some "normal" dates which are in mm/dd/yy format. Is it possible to create
a 2 dimensional array using Jan to Dec and 1 to 12 and then do a lookup to
get from the "mmm" in the spreadsheet to the month number to compare to
the "mm" in the date in the other column? Or do I have to put the months
and numbers into the spreadsheet and do a regular vlookup to convert from
text month to numeric month?

Thanks for your help.