I have attached an example of what I am talking about. The cells in yellow I need to be populated automatically.
I want to take a persons age in years. Given that age a cell by the persons name is populated automatically with an age range that they fit into. E.g: Bob is 22 and his age range is 20-25.
Any thoughts on how to complete?
Bookmarks