# if year=2002 then display "blablabla"

#### drcosmo

##### New Member
Hey,

I have a sheet with member from a sports club. Now with the new season coming, the categories from the members must be changed. It goes by year of birth. Example:

Code:
``````1988 (field K2) 	Junior (field L2)
1989 (field K3) 	Junior (field L3)
1990 (field K4) 	Scholier (field L4)
1991 (field K5) 	Scholier (field L5)
1992 (field K6) 	Cadet (field L6)
1993 (field K7) 	Cadet (field L7)
1994 (field K8) 	Miniem (field L8)
1995 (field K9) 	Miniem (field L9)
1996 (field K10) 	Pupil (field L10)
1997 (field K11)	Pupil (field L11)
1998 (field K12) 	Benjamin (field L12)
1999 (field K13) 	Benjamin (field L13)
2000 (field K14)  	Benjamin (field L14)``````

I have 3 colums: Name, Birthday, Categorie
The values are f.e.
Ali baba - 19/04/1988 - Scholier

The last field is incorrect because his year of birth is 1988 -> the computer should place automaticly "Junior" in the column "category"

Sorry for my bad english, but can anyone help me?

Thankx anyway

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
I would imagine a LOOKUP function will handle this ..... what is the criteria that distinguishes a Junior from a Cadet etc? Presumably Column L contains the Type of Member? If so ... whats a Benjamin?

If you can advise similar to the following, I'm sure someone can help with your LOOKUP if you are struggling ....

YEARS = TYPE

1988 = Junior
1989 = Junior
1990 = Scholier
1991 = Scholier

etc etc

Hi,

Try:

Perhaps this VLOOKUP formula:
Book1
GHIJKL
1lookuplist
3Geri12/3/1989Junior1989Junior
4Stephen1/15/2000Benjamin1990Scholier
51991Scholier
81994Miniem
91995Miniem
101996Pupil
111997Pupil
121998Benjamin
131999Benjamin
142000Benjamin
Sheet1

Replies
2
Views
303
Replies
19
Views
4K
Replies
1
Views
250
Replies
7
Views
637
Replies
1
Views
672

1,219,905
Messages
6,150,901
Members
450,991
Latest member
ExcelDoer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back