What can i use to display a category title based on a cells value?

Hi guys, apologies for the confusing title but i am really stuck on this one!

I am completing a spreadsheet and in it i have a column of peoples ages.

next to this column i have a further 6 columns named:
18-25 26-54 55-59 60-64 65-74 75+

With this, dependant upon a persons age, i would manually tick the corresponding category in which their age falls into, for example:

AGE 18-25 26-54 55-59 60-64 65-74 75+
35 x

Is there any way i can use a formula to calculate what category the age falls under?
or,
can i use 1 column to define the category based on the age value to display their age category?

Apologies for any confusion caused, i would attach the spread sheet but there is too much sensitive data on there

ANY help is GREATLY appreciated.

regards,

excel forum.xlsx


Please find a sample of this attached :D

Brilliant thank you, i have got that to work,

hiowever, i do not want to have to manually input any data on this sheet, i would just for the index formual to match the age against the category and list it in one colum.

if possible?

regards,

use IF() and AND() Funtion

Totally confused,

Fotis1991, im sure your on the right track here but it is still not doing what i owuld idealisticaly like it to do, i am not a pro on excel by any means.

could you input the formula on the attached sample please so i can see this working? i need to be able to includ column H in that index and display the categories in column I,

apologies!