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
    Dave

    Files

    • Book 1.xlsx

      (11.91 kB, downloaded 76 times, last: )