Good Morning
I am trying to find the formula that will give me what year group a child is in. The attached is the data i am working with. The categories I am trying to create are Year 5 their date range is 01/09/2012 to 01/08/2013, Year 4 is 01/09/2013 to 01/08/2014. Any help appreciated as I'm going round in circles.
Year Group Example data 25.11.22.xlsx
Hi Everborntoes and welcome to the forum,
You are looking for a VLookup Table with the last argument as TRUE. See the attached.
Year Group Example VLookup True.xlsx
Here is an example but with grades instead of DOB at: https://www.exceltip.com/lookup-form...-in-excel.html
You will need to build your own lookup table and the values need to be sorted from smallest to largest.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you very much for your help. I will see how i get on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks