Need help building a cross reference table

[Tony Rozynski]

Im trying to create a worksheet that that is a cross reference and looks
like:
A B C D
a1 b1 c1
1 x12 Y Y
2 x13 Y Y
3 x14 Y

From a data list that looks like:
A B
1 a1 x12
2 a1 x14
3 b1 x12
4 b1 x13
5 c1 x13

I've tried a few ways to get the "Y" to appear properly but without success.
Can someone provide some help?

Thanks in advance!

 

[Andy Wiggins]

Assume your data list is in the range F1:G5 and your results table is in the
range A14.

In cell B2 put this formula:

=IF(SUMPRODUCT(($G$1:$G$5=$A2)*($F$1:$F$5=B$1))>0,"Y","")

then copy it into the remaining cells.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"