Check Title VS Gender

[zahidah_mabd]

Hello, I would like to check for title x gender invalidation.

I have two columns which has the value as below

Title	Gender
Mr.	Male
Encik	Male
Mrs.	Female
Miss	Female
Ms.	Female
Cik	Female
Puan	Female

I want to validate the values as follows.

Male =  Encik , Mr.
Female = Cik , Miss , Mrs. , Ms. , Puan

If not then it is invalid.

For example
[Title] = "Mr." and [Gender] = "Female" (Invalid)

Blank values are also invalid
These are some of the Invalid values

Title	Gender
Mr.	Female
	Male
Cik
Puan	Male

Can you help me?

[CNENFRNL]

[Dhacd · Accepted solution]

Good day @zahidah_mabd,
This can be easily achieved using a switch,
Switch(true(),
      title in { "Encik", "Mr." } and Gender ="Male", "validmale,

      title in { "Cik" , "Miss" , "Mrs." , "Ms." , "Puan" } and Gender ="Female","validfemale",

       "invalid")

Proud to be a datanaut,

Marks as solution if this works for you.

Thanks and regards,

Atma.