VLookup calculations on multiple lookups

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:

Please Login or Register  to view this content.

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!

ah, good question. I suppose I forgot to mention that each sales account also has a specific sales name associated to it. So for each sale opportunity, I would want the difference between close dates and campaign start dates.

So, say for falcon, there are 2 sales close dates. For the first date, the name of that sale was falcon.eggs and for the second date, the name was falcon.food. For falcon eggs, I would want to see
30, -10, -133. For falcon food, I'd expect to see 122, etc.

Does that help?
What I'm ultimately looking to do, is figure out which campaigns attributed to the sales. I am saying any sales within 8 months (240 days) of a campaign, will be attributed. Each campaign has a type associated to it, and thus has a specific weight.

Right now, I am taking all campaigns into consideration for an account and I want to get away from that.

Thank you.