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:

Name1	Training1
Name2	Training2
Name2	Training4
Name3	Training3
Name4	Training1

<tbody>
</tbody>

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

	Training1	Training2	Training3	Training4
Name1	x			x
Name2		x		x
Name3			x
Name4	x

<tbody>
</tbody>

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.