[Excel 2010] Fill cell based on content of another
Solved
nlbmoi
Posted messages
427
Registration date
Status
Membre
Last intervention
-
amelie -
amelie -
Hello
In my file, column C contains birth years; I would like it to automatically fill column D with the corresponding age category based on the year.
How can I do this?
Thank you in advance
In my file, column C contains birth years; I would like it to automatically fill column D with the corresponding age category based on the year.
How can I do this?
Thank you in advance
7 réponses
Re,
Do you have a summary table for years-categories???
(I don’t want to make a complicated formula with lots of IF(...)) There will be an IF and a VLOOKUP formula
A+
Do you have a summary table for years-categories???
(I don’t want to make a complicated formula with lots of IF(...)) There will be an IF and a VLOOKUP formula
A+
Hello,
formula to copy in D1, then drag down for the other cells
=IF(C1<>"",YEAR(TODAY())-YEAR(C1),"")
standard number format for column D
Have a good continuation
formula to copy in D1, then drag down for the other cells
=IF(C1<>"",YEAR(TODAY())-YEAR(C1),"")
standard number format for column D
Have a good continuation
Actually, I don't want a numerical result; I would like it to indicate the relevant category.
For example, if I input 1997 or 1998 in C1, I want it to write "cadet" in D1.
I can see that I need to make a link between the year of birth and the category, but I don't know how to do it (I don't want to create a complicated formula with lots of IF(...)).
For example, if I input 1997 or 1998 in C1, I want it to write "cadet" in D1.
I can see that I need to make a link between the year of birth and the category, but I don't know how to do it (I don't want to create a complicated formula with lots of IF(...)).
Already give us the different age categories, but the function could be nice, well it depends on the number of categories.