Thread: matching month and year column.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
earls earls is offline
external usenet poster
  
Posts: 8
Default matching month and year column.

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)
Reply With QuoteReply With Quote