Hi there,

I'm having some Vlookup woes. Here's my situation.

I have a list of accounts with sales dates. I also have a list of marketing campaigns with their start dates, and each campaign is associated with 1 or many accounts.

I'm trying to find the difference between the sales date and the campaign start date.

Maybe some data will help clarify:
          A             B                 C                   D                E  
1 Account_Name_sales Sales_Date Account_Name_campaign Campaign_Name        Start_Date
2 Falcon             2/1/2009  Falcon                  Seminar.Falcon.NY      1/1/2009
3 Falcon             5/3/2009  Falcon                  Seminar.Falcon.NJ      2/10/2009
4 Eagle              3/3/2009  Falcon                  Seminar.Falcon.PA      6/13/2009
5                              Eagle                   Webinar.Eagle.NY       2/2/2009
.
.
.
so basically what I want to do is to take all the falcon sales dates, and subtract the falcon campaign dates

The only way I can wrap my head around this is some kind of array processing, where you take the first sales date, and subtract each campaign date from it, then take the second sales date, and subtract the same campaigns from it.

I have no idea how to implement that, and if anybody could shed some light I would be most grateful. I apologize if the above doesn't convey what I am trying to do, so if you need an example spreadsheet, I can provide one.

Thank you so much!