Combining two data sets using two different fields

[MikiA]

Hello,

I would like to find a solution to combine two datasets based on two unique fields. Tried Fine/Replace Tool and Join but did not manage to get a desired outcome.

My scenario:

Dataset A:

UserID	AddressID	Preferred sports	Preferred fruits
123456		Football
	DEF	Volleyball

Dataset B: 

UserID	AddressID	Preferred sports	Preferred fruits
123456			Apple
	DEF		Banana

Expected outcome:

UserID	AddressID	Preferred sports	Preferred fruits
123456		Football	Apple
	DEF	Volleyball	Banana

[abacon]

@MikiA A combination of Join and a Formula tool is your best option here.

Bacon

[binuacs]

@MikiA one way of doing this