name in a cel must be another name in another cel

[mariovanwetten]

I have a question,

dont know if its very clear what i want.

I have a name in cel ac2 there is a cel called basis/kader
If there is that name then must be in cel AE2 a name called 1C

what is the formula off it.,
i am a teacher and not so good with ecel as you guys and girls.

thanx

Mario

[AliGW]

Welcome to the forum.

Try this in AE2:

=IF(AC2="basis/kader","1c","")

You will need to change commas to semi-colons for your Dutch locale:

=IF(AC2="basis/kader";"1c";"")

If this isn't it, then there are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[mariovanwetten]

Thanx ali,
This is it,

but if i have another name like havo/mavo in the same row in AC2

and is that is havo/mavo and there must be 1A what must i do then ?

[AliGW]

Mmm ... I thought as much.

You can nest IFs, however is that it, or are there many combinations?

In principle:

=IF(AC2="basis/kader";"1c";IF(AC2="Havo/mavo";"1a";""))

[mariovanwetten]

There are
mavo/kader must be 1B
havo/mavo must be 1A
basis must be 1C
basis/kader must be 1C to

[AliGW]

I think you need a lookup table (can be anywhere, even on another sheet):

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	B	C	D	E	F
1
2	basis	1C		mavo/kader	1B
3				havo/mavo	1A
4				basis	1C
5				basis/kader	1C

Sheet: Sheet1

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	C
2	=IFNA(VLOOKUP(B2;$E$2:$F$5;2;0);"")

Sheet: Sheet1

i am a teacher and not so good with ecel as you guys and girls.

I was a teacher of languages for 30 years.

[AliGW]

Was this of any use to you?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.