Vlookup and If formula

  • Morning,

    Can anyone please help me, I have been scratching my head for ages and looked all over the web and I cannot fathom how to do the formula I need.
    I can do a very long multiple if formula, but their must be a better way, maybe combining a VLookup and an If formula.

    I have a very large sheet of dates when projects need to start and a diary from our customer.
    To report to our customer when this work is done it would be better to have a mechanism to define what year & period that the project falls in (column A).

    The formula I would like looks at the date (column B), then by using a formula it looks to see what date range it falls between (columns f & G), then the output finds the correct year & period (column H).

    best regards

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!