Not sure of best formula - Trying IF statement with Xlookup

[shellwig]

Thank you for any help provided. I'm not sure if this is best approach but I'm thinking an IF statement with Xlookup can get me the correct results but I'm having trouble. I am open to other suggestions.

If B1&C1, lookup F&G then return H. My problem comes when I try to get the correct return for C2 - C4. I'm trying to get in 1 formula.

Thank you in advance!

 

[etaf]

=INDEX($H$1:$H$4,MATCH($B$1&C1,$F$1&$G$1:$G$4,0))

BUT not sure on C2 - as its the same value as C1

what are the expected results

Book1
	A	B	C	D	E	F	G	H
1		MRUS	LLY	outlier		MRUS	LLY	outlier
2			LLY	outlier			LLY	Other Mass
3			LOM	outlier			LFI	outlier
4			LFI	outlier			LOM	outlier
Sheet1

Cell Formulas
Range	Formula
D1:D4	D1	=INDEX($H$1:$H$4,MATCH($B$1&C1,$F$1&$G$1:$G$4,0))

 

[Scott Huish]

It would help if you gave expected results in your post, but maybe:

Book1
	A	B	C	D	E	F	G	H
1		MRUS	LLY	outlier		MRUS	LLY	outlier
2			LLY	Other Mass			LLY	Other Mass
3			LOM	outlier			LFI	outlier
4			LFI	outlier			LOM	outlier
Sheet1

Cell Formulas
Range	Formula
D1:D4	D1	=INDEX($H$1:$H$4,MATCH(B1&C1,$F$1:$F$4&$G$1:$G$4,0))