INDEX MATCH a table of X's pulled from another sheet.

[purdue7997]

I'm trying to show a table of X's populated from a different sheet.

On sheet2 I have raw data that is fed from multiple sheets. It shows what degrees people hold.

On Sheet1 I would like to have a table of X's that finds the information in Sheet2.

So the name in A2 would match itself to B1 and find if it matches to the raw data in Sheet2. If it finds it, an X is placed in the table.

How would I go about creating a formula to find this for the whole table? I've attached an example sheet to make better sense of it.

Positive rep to all that help. Thanks!

[benishiryo]

hi purdue. it's much easier with COUNTIFS. in B2:
=IF(COUNTIFS(Sheet2!$A:$A,$A2,Sheet2!$B:$B,B$1),"X","")

if you want it using INDEX & MATCH, it needs to be an array formula. that slows down your file where it's unnecessary for this case. have a happy new year

[purdue7997]

hi purdue. it's much easier with COUNTIFS. in B2:
=IF(COUNTIFS(Sheet2!$A:$A,$A2,Sheet2!$B:$B,B$1),"X","")

if you want it using INDEX & MATCH, it needs to be an array formula. that slows down your file where it's unnecessary for this case. have a happy new year

Works great! Rep coming. Thanks!