Match two values from two columns and return an "x"

[FryGirl]

In this marix setup, I have the uniques from column A in E:G and the uniques in Column B in D2:D4. I would like to find "Neph" and "Cat A" in columns A and B and if a match place an "x". The same for all the other values to find.

So, you can see, "Neph" is found in column A under Cat A and Cat B

Budget.xlsm
	A	B	C	D	E	F	G
1	Hdr1	Hdr2			Cat A	Cat B	Cat C
2	Cat A	Neph		Neph	x	x
3	Cat B	Neph		Cardio	x		x
4	Cat A	Cardio		Pulm		x
5	Cat B	Pulm
6	Cat C	Cardio
Sheet3 (3)

Cell Formulas
Range	Formula
E1:G1	E1	=TRANSPOSE(UNIQUE(A2:A6))
D2:D4	D2	=UNIQUE(B2:B6)
Dynamic array formulas.

 

[etaf]

=IF((AND(COUNTIFS($B$2:$B$100,$D2,$A$2:$A$100,E$1)>0)),"X","")

Book2
	A	B	C	D	E	F	G
1	Hdr1	Hdr2			Cat A	Cat B	Cat C
2	Cat A	Neph		Neph	X	X
3	Cat B	Neph		Cardio	X		X
4	Cat A	Cardio		Pulm		X
5	Cat B	Pulm
6	Cat C	Cardio
Sheet1

Cell Formulas
Range	Formula
E1:G1	E1	=TRANSPOSE(UNIQUE(A2:A6))
D2:D4	D2	=UNIQUE(B2:B6)
E2:G4	E2	=IF((AND(COUNTIFS($B$2:$B$100,$D2,$A$2:$A$100,E$1)>0)),"X","")
Dynamic array formulas.

 

[FryGirl]

Thank you. This works great for me.

 

[etaf]

you are welcome