The user has a very large sheet of dates when projects need to start and a diary from the customer.
To report to the 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 the user 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).
Obtained from the OzGrid Help Forum.
Solution provided by Ingo_Ingo.
|How to use the VLOOKUP formula|
|How to use IF and VLOOKUP formulas together|
|How to maintain the VLOOKUP font format|
|How to insert VLOOKUP into cell with variable array|