If statement with two conditions

[Kpim]

Hi

I have been trying the code below but it doesn't return the result expected. 

Field names:

fruits              Region

A_fruit          Urban_low

O_fruit         Rural_high
 B_fruit         Rural_high             

If(fruit = 'A', 'yellow', if(region = 'Urban', 'yellow, 'blue')

This code returns 'blue' only and I want it to return :

'yellow',

'blue'

'blue'

[BrunPierre]

As below

IF(Match(SubField(Fruit,'_',1),'A'),'Yellow',
IF(Match(SubField(Region,'_',1),'Urban'),'Yellow','Blue'))