Index Match Lookup Help

[manzier]

Hi All,

I have a matrix that I need to update based on a list I have. Essentially, if the list shows completion, I'll need the matrix to be updated with an "x"

Example, I have this table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name1
[/TD]
[TD]Training1[/TD]
[/TR]
[TR]
[TD]Name2[/TD]
[TD]Training2[/TD]
[/TR]
[TR]
[TD]Name2[/TD]
[TD]Training4[/TD]
[/TR]
[TR]
[TD]Name3[/TD]
[TD]Training3[/TD]
[/TR]
[TR]
[TD]Name4[/TD]
[TD]Training1[/TD]
[/TR]
</tbody>[/TABLE]

I'll need to create a formula in the matrix below so that the matrix is updated as the table above is updated, please see below

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Training1[/TD]
[TD]Training2[/TD]
[TD]Training3[/TD]
[TD]Training4[/TD]
[/TR]
[TR]
[TD]Name1[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Name2[/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Name3[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name4[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Is index match the proper way to go? Please help. Thanks in advance!

 

[Takae]

Assuming D2="Name1",D3 ="Name2"...,E1="Training1",F1 ="Training2"...

D2="=IF(SUMPRODUCT(($A$1:$A$5=$D2)*($B$1:$B$5=E$1))>0,"×","")"

 

[steve the fish]

Name1 and Training4 shouldnt have an x? Place first table in A1:B5 then 2nd in D1:H5. Then in E2:

=IF(COUNTIFS($A:$A,$D2,$B:$B,E$1),"x","")

Drag across and down.