Look up and place certain dates within months with an extra lookup

[simmo86]

Hi,

I posted a problem last week that was solved regarding looking up certain dates and then putting them in a monthly calendar which worked perfectly. Now I have multiple data to put into the same sheet and I am not sure how I can do it using multiple lookups. I have attached an example of what I am trying to do.

I have worked out salaries for individuals and they receive pre arranged salaries each year and for the benefit of cashflow I am trying to lookup from their startdate, add on the years and match the expenditure to the calendar. Not sure if it is possible to do, been scratching my head about it!

Any help would be much appreciated and thanks for solving the issue last week.

Kind regards,

Alex

[teylyn]

Hi Alex, try this on Sheet2 and copy down and right. Cell B2

Please Login or Register  to view this content.

hth